How to query a subform

[JulieAsking]

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

 

[Rich]

Do you have a separate table for operations?

 

[JulieAsking]

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

 

[Rich]

Seth

 

[dan-cat]

Probably a type - she meant Beth

 

[Rich]

She's seen me out on the town?