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.
Defining default value on a report?
Collapse
X
-
Base the report on a query and have the query convert the Nulls to zeroes using Nz(FieldName, 0)Originally posted by NeekosThe 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.
Comment