USMarine430
New member
- Local time
- Today, 10:48
- Joined
- Feb 2, 2012
- Messages
- 6
I currently have a report linked to this table. The sole function of this table is to association a two letter code with a program name. When the report runs, it prompts the Query to ask first:
Program Name
Warehouse
Month
If nothing is selected the query by default will elect a wildcard search, resulting in everything you don’t specifically ask for.
All of this will feed into a report. In the report I have 2 text boxes – one is linked to a separate table which references the months of the year, joined to my master table so when a month is chosen, the text box auto-populates with the letter month.The other text box is for the program names.
My question is – If a wildcard is elected by not entering anything, can I create an entry on the joined tables for “ALL AGENCIES”, “ALL MONTHS”, or “ALL PROGRAMS” that will be selected by default if the wild card is chosen?
I have tried leaving the table entry blank, "*". Is there maybe an expression i can build? or some SQL language i can add?. . . so far nothing works - but then again I am quite the noob . . . Thanks for posting!
Semper Fi
Dave
Program Name
Warehouse
Month
If nothing is selected the query by default will elect a wildcard search, resulting in everything you don’t specifically ask for.
All of this will feed into a report. In the report I have 2 text boxes – one is linked to a separate table which references the months of the year, joined to my master table so when a month is chosen, the text box auto-populates with the letter month.The other text box is for the program names.
My question is – If a wildcard is elected by not entering anything, can I create an entry on the joined tables for “ALL AGENCIES”, “ALL MONTHS”, or “ALL PROGRAMS” that will be selected by default if the wild card is chosen?
I have tried leaving the table entry blank, "*". Is there maybe an expression i can build? or some SQL language i can add?. . . so far nothing works - but then again I am quite the noob . . . Thanks for posting!
Semper Fi
Dave
