How to query a subform

JulieAsking

Registered User.
Local time
Today, 11:17
Joined
Jan 5, 2002
Messages
34
Hi. I'm a novice but I managed to construct a MS Access97 db which is working well as far as inputting data. However, I have a problem with querying. The db is a record of patients and their surgical operations. The construct is a subform (continuous) within a form. Querying works fine if the patient had just one operation, but if a patient has had more than one operation the query is not picking the additional operations up. That is, it is only reading the first record from a subform and ignoring the second or third records.

I want to do a Report based on a Query showing all patients in the db, their operations and the dates they took place.

Can some kind person please tell me in lay terms how I should be setting up my Query so that if Joe Bloggs has had 3 operations they will appear by date order next to his name in the Report?

Thanks - Julie
 
Thanks so much for replying Seth. I apologise but I made a wrong assumption about a particular query outcome. On re-doing the query all is well.

Thanks again - Julie
 

Users who are viewing this thread

Back
Top Bottom