Report can't use a filtered query?

[TCARPENTER]

I have a report based on a query which has a filter applied, when I set the the record source property to this query, the filter on property becomes automatically populated with the filter specified in the query. However, when I run the report I get the following error:

'Owner.OwnerName' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

Here is the filter property:

((Lookup_Software_OwnerID.OwnerName="ABC Inc"))

I've tried all sorts of different combinations but none seem work - the query however works fine. I (obviously mistakingly so) assumed since Access did this on its own, it would work fine.

Any help would be appreciated.

Thanks
Todd

 

[dhookom]

I'm not sure how you are applying the filter since I don't use this "feature". I expect that your issue is that your filter includes the table name. A report doesn't have the table/query names, only the field names. I assume you have only one "OwnerName" field in your report's record source. Therefore, you filter should be:
OwnerName="ABC Inc"

Duane
MS Access MVP
Find out how to get great answers faq219-2884.