R
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
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