accessaspire219
Registered User.
- Local time
- Today, 13:39
- Joined
- Jan 16, 2009
- Messages
- 126
I have a union query the SQL for which is as given below:
One of the columns of the union query is a month column, I want to add a parameter to this query which will prompt the user to enter the month that he wants to view. Normally I would have done this in this design view (in the parameter row) however I cannot do so here as this is a union query. Any idea on how I could specify parameters in this query?
Thanks.
Code:
TABLE MIOH_MONTH UNION TABLE SERVICE_MONTH UNION TABLE SURPLUS_MONTH UNION TABLE TRFALL_MONTH;
Thanks.