Working with Null Values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathy - 19 Dec 2006 12:03 GMT

I have a report that calculates weekly payroll. It is broken down into 4
categories. Employees making under a specific wage, the OT for those
employees, Employees making over that wage and those employees OT. My problem
is if there is no OT for either group I get all #Error messages in all
fields. Is there a simple way to tell the report that if there are no records
to count/calculate to put in a zero? I am a novice and do not write code
well.
Thanks in advance for any help you can provide.
Kathy

Reply to this Message

Allen Browne - 19 Dec 2006 13:22 GMT

Test the HasData property of the report to see if it has any records.

Presumably you have a text box with some kind of calcuation such as:
=Sum([Amount])
Change it to:
=IIf([Report].[HasData], Sum([Amount]), Null)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a report that calculates weekly payroll. It is broken down into 4
> categories. Employees making under a specific wage, the OT for those
[quoted text clipped - 7 lines]
> Thanks in advance for any help you can provide.
> Kathy

Reply to this Message