Union Query to return line if query is blank

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Never mind - I sorted it out by adding a permanent value in a different table
and joining them so that there would always be a record even if the original
query was blank
 
Back
Top