Crosstab Query question

G

Guest

I have a crosstab query that counts the number of occurances for every
location. The query is set to read a location table and an issue table. It
then creates an output that displays all locations, and the count of how many
issues are for each location. However if a location does not have any issues
there is just a location and no count. The user needs the count to be "0".
Is there a way to have a "0" replace the null value in the output?
 

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

Query is too complex 5
Crosstab Query Question 5
crosstab query child table count 5
dcount in a crosstab query 3
minimize repeating query criteria & generating monthly YTD totals 1
In crosstab query, how do I count not including duplicates? 2
A Complicated Query Question 4
Make-table query with around 2 ml records taking too long 0

Top