Blank or $ 0.00 that is the question?

[Lou_Reed]

In the following tutorial shown here:

http://www.functionx.com/access/Lesson23.htm

I am working on the College Park Auto Repair database.

Now I think that everything is fine in the list of Parts Used and in the list of Jobs Performed.

But here is the problem : what to do about blank spaces. In other words, for the entries in the two examples
the Parts Used and Jobs Performed their number never reaches 5 (the full amount allowed) so there will be blank spaces.
after the parts and jobs are entered. The question should there be any entry there at all either:
a blank space or an entry of $ 0.00. I vote for the former.

I have seen it both ways on reports I have got from auto repair/dealers. However, I like the blank
space. If you see nothing then you automatically know it is $ 0.00, you do not have to be told.

However, how do I put that in the design view of the report?

The first way:

=Nz([UnitPrice4])*Nz([quantity4])

puts $ 0.00 in the proper place on the report. It does not leave it blank.

But the second way

=Nz([JobPrice4])

leaves the position blank - period. I like this one.

So how do I get the first input to look like the second one shown?

I will grant you that the first one involves a calculation and the second one does not.

But how to make the first output look like the second output?

Any help appreciated.

Thanks in advance.

Respectfully,




Lou Reed

PS The inputs were copied directly from the screen so their is little chance
of transcribe error. They are the same as are the ones in the report.

[June7]

Maybe don't use Nz() function?

[Lou_Reed]

Remove the Nz on the first option and then it will just show a blank space?

How come on the second one I did use the Nz function and it did show a blank
space.

So change this :

=Nz([UnitPrice4])*Nz([quantity4])

into this:

=([UnitPrice4])*([quantity4])

I will try it.

Thank you very much.

Respectfully,

Lou Reed

[Lou_Reed]

I stand corrected. I did not use the Nz in the second output. That is why it is printing a blank
and not $ 0.00.

Respectfully,

Lou Reed