Using query as filter

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

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!!!!
 
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.
 
Back
Top