Syntax Where Condition in Macro

J

JackG

I have a report based on a query. The query has a criteria set ('Program'
field from 'Client' Table needs to select records with crieteria of
"highroad" Or "Aftercare". The query runs fine alone and picks records from
'Client' where the 'Program' field contains "highroad" Or "Aftercare". The
report runs fine. When I call the report from a macro (OpenReport) I am
being prompted for the parameters for the 'Program' field?

What do I need to do. If the answer is set the With Condition on the
OpenReport macro, what is the syntax and do I remove the criteria from the
query? Table = Client, Field=Program, Values "Highroad" Or "Aftercare"
Query=Query-AllClients, Report = Report-AllClients. Please help, I have
tired everything I know and nothing is working. What is the syntax for an
expression in the With Condition of an OpenReport Macro.
I am using Access 2003.

Thank You,

Jack G.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top