I have a report that does commission calculations in the footer of the report. It has a text box that is the result of a query. If the query has a blank results list the text box displays error and then the ensuing calculation creates another error. How do I force the text box to take 0 as the value if the results of a query is empty. basically I am just taking the total amount distributed for an individual....If an individual did not get an disbursements, then the result is null instead of a total calculation.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
error when there are no records
- Thread starter MICKI0220
- Start date
In reports, you can use syntax like
Duane
Hook'D on Access
MS Access MVP
Code:
=IIf([HasData], /YOUR EXPRESSION HERE/ ,0)Duane
Hook'D on Access
MS Access MVP
- Thread starter
- #3
How about you provide the control source of your text box that you have an issue with? I'm not sure how you display "result of a query".
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Thread starter
- #5
Not at all what I guessed you had.
Try:
Duane
Hook'D on Access
MS Access MVP
Try:
Code:
=Nz(DLookUp("draw_total","qrySlsRepDrawHistoryPaid") ,0)Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question