Using query as filter

[Golfinray]

Can you use a select query as a filter in a report? If so, please help with
the syntax. I tried putting in the properties and could not ever get the
syntax to work. I am not using that query as a source for the report. Thanks
so much!!!!

 

[Arvin Meyer [MVP]]

Yes, create the Select query and either save it and use its name as the
recordsource property of the report, or copy the SQL from the query, and
paste it in the report's recordsource. Either method should work.