Originally Posted by
camkam
Thankyou for your reply. I will try and explain as best I can. (Pretty basic I might add!!)
Ok, so my Data is in a table (called JOBDATA) (some are currency and some are just numbers are all defulted to NULL) and I enter the information on a form (ENTER NEW QUOTE) in which the fields have come from my table "'jobdata"" (I put these fields on the form by going to ""Add exisiting field" ALSO I have a total field on my form which also comes from JOBDATA , but the total fields have a calucation put in them at the table . so my problem is. If I don't fill in every field and leave some blank on the FORM there is no total, and if I put a zero in every field on the form it totals okay but the report comes out with zeros. What I want is the report to have nothing on it if zero. If this is too hard to understand dont'worry _ I will try and send it to someone to look at. Im quite happy to pay someone ... I am getting so CROSS! Many thanks