Multiple Parameters query report

[Guest]

Me a novice and have a question that I hope won't confuse everyone further.
what I am trying to achieve is retrieve the demographic information of all
participants in a reserach study who meet certain criteria like may be
cholesterol level > 250 or who have diabetes. If they do meet the criteria, I
want to be able to generate a report that contains all their address
information.

I have setup a parameter query that asks for the criteria of interest and
pulls up all the participants who meet that criteria. How do I go about
setting up it in such a way that I can use multiple parameters of the same
type. For instance, I can set the query to accept parameters for let's say I
am interested in all participants over age 65 (age parameter), males (gender
parameter), who have hypertension and came to our facility after 2005. But if
all I want to do is pull all the patients who have hypertension, OR/AND
diabetes, OR/AND hypercholesterolemia (these all fall under the same
parameter of disease)

=> Another quick question: Is there a way to print mailing labels directly
from MS Access, based on the above query i.e. let's say from the query above
we get a set of patients and now I want to be able to print mailing labels
for their address information. Any help is greatly appreciated.

Thx
Hada

 

[Guest]

HI, I am a novice as well, but I have done something like this before.
I have a paramater query on an employees database that look up birthdays by
month. It prompts you for the month, and brings up all birthdays in that
month.
I designed birthday cards and envelopes seperately in a mail merge in MS
word and based the mail merge on that query in that database. When I open
the Mail merge in Word it automatically links to the database, and the
specified query. It prompts you with the paramater ("Which Months Birthday
cards do you want to print") and once entered returns the proper information.
You hit merge and you have the info.
I beleive you can put in multiple paramaters, but you may have to put them
each on their own seperate line in the criteria section.

I hope this helps.
Todd