Query (Parameter? Criteria?)

monks89

Registered User.
Local time
Today, 03:26
Joined
Mar 26, 2009
Messages
19
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.
 
The best way to tackle this is to drive it from a Form using a combo box to select the parameter, this selected parameter is then also available for the report.

brian
 
Thanks for the quick reply, but how would I go about doing that? I'm sorta new at this. I found an article.....would this be what you're talking about? Thanks
 
I've not seen that before and after a quick read i would say yes it gives a thorough step by step guide,

The info selected for the query is available to the Report in the same way.

Brian
 
Further info I feel I ought to add as you say you are new is that the Criteria under say the RMA checkbox column in the query will be

(RMAcheckbox=TRUE and forms!formname!combo="RMA") Or (forms!formname!combo="ALL")

This is repeated for all 3 checkboxes, obviously using your own names.

Brian

Oops got myself crossed between SQL and the Design grid, the latter only needs
(=TRUE and forms!formname!combo="RMA") Or (forms!formname!combo="ALL")
 
Last edited:
I'll see if I can figure this out....thanks for your help so far.
 
Got it....created a form to allow switching between the 3....Thanks for your help.
 

Users who are viewing this thread

Back
Top Bottom