Crosstab not returning all results

[Rob]

Hi,
I am reasonably new to Ms access, I hope someone can point me in the
right direction. I have a crosstab query set up with a row heading of
"status" and a column heading of "teams". The status is always either
"Assigned" or "Null" or "Monitored" there are only ever 4 teams say A-B-C-D.
My difficulty is with counting how many jobs were received by each team for
yesterday ....day()-1. It's not a problem if they all received work, but
that's not always the case sometimes 1 or 2 of the teams don't receive any
work, so what I was hoping would happen is always show all teams in the
column header and if they don't receive any work show "0"as their return. At
present if some of the teams don't receive work they are missing from the
column header.
Hope this makes sense
Thanks in advance Robert

 

[Duane Hookom]

You can add all the teams to the Column Headings property of the crosstab,

 

[Rob]

Duane many thanks for your prompt response, I'll try it when I get back to
the office.
Robert