I have a database and I would like my (Time-Based Template) query to do something specific.
In a form (Data Entry Form), there are 3 checkboxes entitled Service, RMA, and Factory.
I want my query to be able to ask the user to type in either "Service", "RMA", or "All".
If "Service" was typed then all entries with the service checkbox checked would appear in the query.
If "RMA" was typed then all entries with the RMA checkbox checked would appear in the query.
If "All" was typed then all entries would appear regardless of which (if any) of those 3 are checked.
If they did not type one of those 3 then something could popup telling them to input the correct spelling to avoid any problems with that.
Can someone help?
Here's the link for my database. Thanks
Also.....instead of using the query I have a report set up that utilizes the query to make it more user friendly.
One more thing, if the report could have a label appear somewhere in the heading to reflect what was selected so they know what the typed.
A label next to the title of the report stating "Service Records", "RMA Records", or "All Records" depending upon what was input would be perfect.
In a form (Data Entry Form), there are 3 checkboxes entitled Service, RMA, and Factory.
I want my query to be able to ask the user to type in either "Service", "RMA", or "All".
If "Service" was typed then all entries with the service checkbox checked would appear in the query.
If "RMA" was typed then all entries with the RMA checkbox checked would appear in the query.
If "All" was typed then all entries would appear regardless of which (if any) of those 3 are checked.
If they did not type one of those 3 then something could popup telling them to input the correct spelling to avoid any problems with that.
Can someone help?
Here's the link for my database. Thanks
Also.....instead of using the query I have a report set up that utilizes the query to make it more user friendly.
One more thing, if the report could have a label appear somewhere in the heading to reflect what was selected so they know what the typed.
A label next to the title of the report stating "Service Records", "RMA Records", or "All Records" depending upon what was input would be perfect.