Hey guys,
How exactly does the Where argument work?
For example: I have a query that is ran for sales data. It includes our 3 states: Texas, Florida, Utah. Those states are spelled out like that in the Region field of the query.
I was hoping to only have 1 query, 1 report design, and 3 lines of DoCmd.OpenReport to print out the report for each state.
This is hypothetical, as my process is a bit more complex, but I just need to learn the syntax.