 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / December 2007Using query as filter
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.  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > 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!!!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.