Multi Querie

[micqual]

Good Afternoon,

I need to be to create a Query that will show a 0 for no record.
My form is made up of a Name and a Course name.

e.g.:

Michael Underwriting
Scott Underwriting
Michael Claims
Michael IT

My End result needs to be

Name Underwriting Claims IT
Michael YES YES YES
Scott Yes 0 0

I have created 10 individual Queries filtering out each course
but then I join them together by Name it will only show Michael.

I hope its not a case of adding records for scott as I have 10,000 Names

Thank you

 

[lightray]

you need to Nz(Your formulas),0) to generate a zero response to no data

lightray

 

[Adeptus]

and make an OUTER join, not INNER
(so you get all of the names table, not just those with matches)

 

[micqual]

Thank you Both.

Thank you for your Quick responses