Refering to a query in a report

[JReichnan]

I have a query call Names where I filter for a single Last Name in a Last Name Field. How do I right an expression that brings that Last Name from that query into my report when this report is based on an entirely different table. Perhaps I am having a syntax problem

 

[SammyJ]

You can base the report on a new query which joins the table and saved query on the Last Name field.

You don't even have to create a saved query to do it. The report can hold its own derived query as a recordsource. Just go to the table name in the report properties and click on the little button at the right which appears when the cursor is in the box. It will say 'This is a table. Do you want to base the report on a query based on this table?' so say yes, and you'll get the familiar query grid. Add the saved query in and make the join. Exit and make sure you update the property when it asks, and try that.

Sam.