Hi, I’ve lurked for a bit and certainly hope you folks can be as much
help to me as you have been to others.

My problem is basically trying to query several results in a single
field (“or” type) but I would like to do so as a parameter so it prompts
me when I open the report.

I am working with MS Access 2000.

Here is my situation.

I am dealing with a database that has 400+ records. It is of accounts
that I have to visit (testing of fire systems) at various times of the year.

Some accounts I test once a year and some monthly with several
variations in between. In addition to keeping the information on each
account up to date and easily sending reports up the chain showing the
progress for the year I also use it to give me a list of accounts coming
up for test the next month.

I have a field called test interval (not visible in any reports) and use
codes such as A03 (annual test in march), S03 (semi-annual starting in
march and again six months later in Sep.) Q03 (quarterly in march, june,
sep and dec)…. You get the idea I also use T## for three times a year,
B(1 or 2) for bi-monthly(every other month) and M for monthly

This way I have been using a basic query and calling up my report each
month. For example, to see the tests I have to do in October I have to
modify my existing query with “test interval” to equal M, A10, S04, Q01,
T02 and B2. Not a huge pain in the butt but it is cumbersome and I have
to go in every month and modify it.

I have recently started using parameters and think it would be
marginally easier to fill out prompts upon opening the report. I tried
a “=[x]” on several lines but it still only prompted me once. I tried
using a ‘getparameter’ statement which I heard of but that did not work
(no claim that I did it right).

Is there a way to get the multiple prompts?

OR
Can I make 12 queries and have the report prompt me for which query to
use when I open it?

OR
Am I going about this like a lunkhead and everyone reading this is
seeing a better way of doing this entire process? I have no problems
adding new fields to my table if it ends up being more efficient.

Thanks for your time.

Joe