S
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
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