Thank you very much it worked... %1 was the command I was looking for and could't figure it out.

Also,is there a way to place a command such as:

IIF(qty%1 = 0, 999999, 999.99)

in the Format Expression of a text box on a report.