Dont show 0 in report...

[stephendeloach via AccessMonster.com]

In my report I have a NetAmount which is =Nz([Quantity],0)*Nz([UnitPrice],0)
Sometimes I dont want to have to enter anything in the Quantity field because
I dont want to person being billed to know the Quantity. Is there a way I can
just enter the UnitPrice in the form and in the report under NetAmount it
pulls the UnitPrice to the NetAmount? Also, under the Quantity I dont want it
to show 0 when it is 0. How do I do that? THanks

 

[missinglinq via AccessMonster.com]

"I dont want to person being billed to know the Quantity"
What kind of scam are yu trying to pull?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com