Show All Records

[ozzroo]

Hi

I have two tables. Courses and Participants.

The participants form is a subform of the courses form.

Some of the courses have no participants and when I go to run my query on a list of the courses to see how many participants there was for each course, it is missing out the courses where there were no participants.

how do i include all courses so that i can see even the courses that have no participants

i want to see the course, total booked, total attended

any help would be great

thankyou

 

[PHV]

Take a look at outer joins:
SELECT .... FROM .... LEFT JOIN ....

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ozzroo]

thanks for your reply

i will have a look at it