InfoPath Dev

Hi I am very new at this so I need some help with a form that I am creating.
I have a form that allows the user to enter a start and end date range that the person requiring medication. This data is then saved into a access database. Is there a way of creating a form of a particular date that would tell me who is to have there medication.
Ie person1 takes medication from the 01/02/2006 till 20/02/2006.
If I run the report on the 11/02/2006 person1 will be in the report.

Hi,

Are you saving person1 name in access database if you save person1,
this is related to access than infopath.

Thanks.

K.Ramana Reddy
Infopath Dev India

Hi

Write a specific select query in your database and links its results to the form to pull up the results and hey presto, Job Done.

I'm from WALES
[email protected]