Return all appointment types

[AccessQuestions via AccessMonster.com]

I have a query that uses three tables. ApptType, Client and ClientAppt. The
ClientAppt table has a foreign key called ApptTypeID, which is linked to the
table called ApptType. Also, the ClientAppt table is linked to the client
table with a field called ClientID, Client ID is the primary key in the
client table and is a foreign key in the ClientAppt Table. What I want is
all the male clients to be displayed, and show the number of appointments
that males client have had, and I want all types of appointment to show up
weather or not that type of appointment was used and it would just display a
zero. I have the links done properly (I think) and have the link to the
apptType table to clientappt set to include all records from the apptType
table. If I run the query without any criteria is works fine and even
displays appointments not used and display a zero value which is what I want.
However, the problem occurs when I place the “male†criteria in; it drops all
appointments type not used. As mentioned I want all appointments type
display even if they are not used and just to display zeros. I will need to
use other criteria as well, but need to fix this issue first.

 

[tina]

try setting the criteria on the "gender" field to

"male" Or Is Null.

hth