I have developed a report which is displaying the data I want. In that report are two fields which are number fields. Some times these fields contain a six or seven digit numbers, some times they are blank, and at times they contain a zero in one or both of these fields in the table.
What I would like is to print a report, but if one or both of these fields do contain a zero, not print it, just leave it blank on the report.
Have tried various IF THEN ELSE statements and others in both the report and query to get rid of the zeros and replace them with a blank, so far nothing seems to work.
This can not be all tha difficult to program, but I have gone through all the Access books I and come up with blank.
Anyone have any ideas.
Chuck