Crosstab Query display all data

R

RA

I'm trying to get a crosstab query to display all people
in the table, even those who do not have data input for
the time period.

Currently only the people with data is displayed, I need
to know who has zero.

RA
 
A

Allen Browne

You have a table of people, and a related table of data?

If so, double-click the line joining the 2 tables in the upper pane of the
query design window. Access pops up a dialog offering 3 options. Choose the
one that says, "All records from the People table, and ..."
 
Top