I have a report showing how many projects were done in a particular year, for each state in the US.
Query organization:
The only way I was able to figure this out was to make a separate count query of project numbers for each state, then combine all those querys into one query that the report is based on. (Report Query).
Problem:
If a state has no projects for a particular year, the count query for that state shows no records. If I put this query in the Report Query, the Report Query shows no records for all 50 states. If the count query had a null value for the state, I could deal with that with IIF.
Any ideas?
Query organization:
The only way I was able to figure this out was to make a separate count query of project numbers for each state, then combine all those querys into one query that the report is based on. (Report Query).
Problem:
If a state has no projects for a particular year, the count query for that state shows no records. If I put this query in the Report Query, the Report Query shows no records for all 50 states. If the count query had a null value for the state, I could deal with that with IIF.
Any ideas?
