Query Error

[barnett]

I have a query with the critieria of the "Date()" along with other fields that I need added together. I have this set to print to a report and it works as long as it finds at least one record. My problem is I need the text blocks to reflect 0 or nothing, on the report, if the query returns no records.

[Scott Price]

You have posted your question in the Access Articles section rather than the Access Forum section.
I have moved it across for you.

MODERATOR.

[NeoPa]

Barnett,

You'll need to describe what you're after a little better. This doesn't describe what you're doing or wanting very well I'm afraid.

[barnett]

I have a query set to search using a Date() function. On the report I have it set to add other fields in the query(which have no critera). The problem is when the query finds no records I get an #Error for each text box.

Query:

SELECT [Movement Flow Chart].Date, [Movement Flow Chart].[Onload PAX], [Movement Flow Chart].[Onload Cargo], [Movement Flow Chart].[Thruload PAX], [Movement Flow Chart].[Thruload Cargo], [Movement Flow Chart].[Offload PAX], [Movement Flow Chart].[Offload Cargo]
FROM [Movement Flow Chart]
WHERE ((([Movement Flow Chart].Date)=Date()));

Example of one text box on the report:
=Sum([Offload Pax])

Is there any way I can set the report to shows 0 if the query finds no records?

[NeoPa]

I suspect the report is running off the last (AddNew) pseudo-record of the dataset.
I don't think it makes logical sense to process it like that and show any zeroes. Instead, if you don't like the default behaviour, consider putting in some code in the OnOpen event procedure that closes the report if there are no records. It could be a bit more user-friendly and pop up a message box to explain too if you like.