By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,289 Members | 1,804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,289 IT Pros & Developers. It's quick & easy.

Defining default value on a report?

100+
P: 111
The report i have is based off of a table where the user either enters BookingNumbers one at a time, or AmountWorked for items that have no booking numbers. On my report, i have a Count of the booking numbers and a Sum of the AmountWorked. Now i want to add those two values together to get an overall total, but it doesn't always work because sometimes AmountWorked is null. I dont want to set the default value of AmountWorked in the table to zero because there is lots of other error trapping code that checks if it is null. Is there a way i can set this on the report? or somewhere i can put an If/then in the report to set it to zero if its null? Or do i have to set the default in the table and go back and change all the code that checks to see if its null? Sorry if this is confusing. I'm still pretty new to Access.
Aug 14 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,392
The report i have is based off of a table where the user either enters BookingNumbers one at a time, or AmountWorked for items that have no booking numbers. On my report, i have a Count of the booking numbers and a Sum of the AmountWorked. Now i want to add those two values together to get an overall total, but it doesn't always work because sometimes AmountWorked is null. I dont want to set the default value of AmountWorked in the table to zero because there is lots of other error trapping code that checks if it is null. Is there a way i can set this on the report? or somewhere i can put an If/then in the report to set it to zero if its null? Or do i have to set the default in the table and go back and change all the code that checks to see if its null? Sorry if this is confusing. I'm still pretty new to Access.
Base the report on a query and have the query convert the Nulls to zeroes using Nz(FieldName, 0)
Aug 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.