Show records with 0 total in a sum query

D

deshg

Joined
Mar 17, 2007
Messages
1
Reaction score
0
Hey everyone,

I have a query displaying total customers within specific sectors using the groupby and sum arguments. The only issue being it doesn't display sectors with 0 customers at all (i would like it to list them with 0 total). I just wondered if there was a way of doing this or whether it will only ever show results with positive counts?

Thanks so much,

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing records with 0 total in a group by/sum query 2
SUM in a UNION query 2
Sum a count total 2
Union query not displaying select statement 1
Having Trouble with Sum in a Query 1
query showing - number and + total 1
Total Row to Sum a Column 1
Format field to Percent w/ 2 decimal places using IIF statement 3

Top