G
Guest
Just wondering if anyone can help me with a problem I am having.
I have created 4 crosstab queries to create a report for the Board broken
into columns by department
1. How many enquiries
2. How many active clients
3. How many enquiries withdrawn after going nowhere
4. How many closed accounts
I have then join these into a union query so that all the results display on
one query My problem is that if, say, no accounts have been closed, the
information simply doesn't show on the union so instead of getting 4 lines
the board only sees 3.
I would like the closed accounts query to show up as zeros even though the
first query is showing nothing.
Does anyone have any ideas.
Many thanks in advance
I have created 4 crosstab queries to create a report for the Board broken
into columns by department
1. How many enquiries
2. How many active clients
3. How many enquiries withdrawn after going nowhere
4. How many closed accounts
I have then join these into a union query so that all the results display on
one query My problem is that if, say, no accounts have been closed, the
information simply doesn't show on the union so instead of getting 4 lines
the board only sees 3.
I would like the closed accounts query to show up as zeros even though the
first query is showing nothing.
Does anyone have any ideas.
Many thanks in advance