Subscript out of range error

[LRICE]

When creating a report from a query that is based on 2 tables that are
linked, I receive the subscript out of range error. The query runs without
any errors but the report wizard will not create the report.