No data return from a sub-query causes an error message

C

Claire Milligan

I have a sub-query which counts the number of referrals received [Date Received]. The user then enters the criteria of the time period between [start date] and [end date] and the locality [Town]. There are 9 different localities. When the query is run and there have been no referrals in a particular locality, the table appears as column headings with no data. The query that this links into (as do several other sub-queries) then also returns no data.

How can I get the first sub-query to return data for each of the different localities, with 0 if there have been no referrals?

If someone can find me a solution I would be delighted! Thanks in advance.

A Womand Told Me
http://www.awomantoldme.com
 

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 returning data for every day of a period. 1
query to show where no data in a stated column 0
No Current Record - Before Code Even Runs! 0
Data Collection Via Email -- error message that does not make sens 0
Report Using Crosstab Query Causes Errors 3
Can we create multiple pivot tabel views for a singleaccess query? 1
How do I Transfer Data from one table to another 6
Issue with absolute walues in a yes/no table 6

Top