Great Day, I have a report that is printing an invoice for services performed on a vehicle at a automobile repair shop. the report loads customer and vehicle data, along with totals from two subreports: one shows the work that was done on a vehicle - oil change, replace front brakes pads, etc; and the other one shows the parts that were needed for the job - oil, oil filter, air filter, etc. In one report no parts were used, so that subreport does not print, and the total fields in the parent report: "Total Parts", "Total Tax," and "Total Repair" all display "#Error".
I suspect that these errors are the result of no data in the parts subreport; however, the "Total Parts", Total Tax", and "Total Repair," fields all have the Nz(Field name) function, which I thought would produce 0.00 if that parts field was null.
Thanks in advance for your assistance.
r/David
Jumat, 23 September 2011
[MS_AccessPros] Report not displaying "0.00" from a null subreport
__._,_.___
MARKETPLACE
.
__,_._,___
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar