Use a form to populate a report

[SeanK6876]

Hello Again...

I've searched the message board and can't find any direct answer to my
question.

I work in a blood draw room and use access to track patients. We have
mulitple phlebotomists. I would like to create a report for a particular
phlebotomist.

For example. I want to have a form where I can say I want a report to show
me all the patients that Joe Smith drew on 12/21/2005. Then have the report
show that information.

Any help is greatly appreciated!

 

[sbshelp]

yeah use a query that has a paramerter in the date field. in date field
under "criteria" - type this [please enter date]

 

[SeanK6876]

Sort of...I was hoping to avoid filtering just because I'm assuming that the
people utilizing this database aren't computer literate.

I do have three tables (*) denotes Primary Key:

DrawData
(*)DrawDate
(*)PhlebName

PatientData
(*)ID
SSN
LastName
FirstName
MI
DrawDate
PhlebName

Phlebotomist
(*)PhlebName
Phone
Email

I want the user to open a form from a switchboard that asks for a date
(unbound) and a phlebotomist (unbound) and send it to a query for a report.

 

[xRoachx]

Hey Sean, you can find what you need here:

http://www.fontstuff.com/access/index.htm

It's a good starting point.