Multiple Parameters query report

[Hadavidi]

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

 

[Access Idiot]

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

 

[DB Diva]

Hi Hada,

I have a suggestion for printing the envelope. I used to have to enter
client's requests for information into my form but when I went to print it
would print the whole form.

My solution was to create text boxes on the form that captured the mailing
info. Under the properties for each box, I set to Print Only (not display)
and I made them not visible in Data View so I won't see them when I was
entering information. Make sure all other fields/controls/text boxes are set
to display only. You will be able to tell after your first printing.

Next I made a control button to "Print Envelope". It would only print those
few text boxes. I had to play with the spacing in Design View and it was a
bit messy where things overlapped but it worked really well. I had to send
out 300+ requests a year. I saved a lot of retyping.

Hope this helps. J.