Need to display waiting list

[foxtet]

I'm developing a small database to manage patient's data as a part of my assignment. I need to display list of patients waiting for a doctor or doctors. when a patient from that list is checked it should be deleted from the list meaning when consultation started the patient name should be removed from the waiting list.

It can be very helpful if any one can just tell me how can i do this.. Im using Ms access 2010l.

foxtet

 

[Trevor G]

You need a query to do this, and either use a date field or check box field. If patient has a seen by date then set the criteria to Is Null if you are using a check box, has been seen then set the criteria to False.

 

[foxtet]

Thank you for the reply
can you prepare a sample db for me to get this done. i tried couple of times but not getting what i need.
fox

 

[Trevor G]

This is a very simple database, 1 table list of Patients and Consultants. Multiple Queries with different types being used.

I don't know how complicated your tables are and what data fields you are using.

See what you think.

If you need to strip down a copy of the database and upload it, it can only be 2mg big, so you might need to zip if first.