Querry IIf Output Format (Access 2003)

[Bruce]

I have a multiple IIf statement in a querry that calculates cost based on "NumberofDaystoBill x 10" (as an example). I need the "Cost" output to be formatted as currency instead of number.

Part of the IIf statement in the Querry:

Cost: IIf([BILLING]="EXTENDED",([NUMBER OF DAYS TO BILL])*10,(([NUMBER OF DAYS TO BILL])*5)))



Thanks!

I tried to add FORMAT(Cost, "Currency") but it didn't like it.

[PianoMan64]

I have a multiple IIf statement in a querry that calculates cost based on "NumberofDaystoBill x 10" (as an example). I need the "Cost" output to be formatted as currency instead of number.

Part of the IIf statement in the Querry:

Cost: IIf([BILLING]="EXTENDED",([NUMBER OF DAYS TO BILL])*10,(([NUMBER OF DAYS TO BILL])*5)))

Thanks!

I tried to add FORMAT(Cost, "Currency") but it didn't like it.

Cost: FormatCurrency(IIf([BILLING]="EXTENDED",([NUMBER OF DAYS TO BILL])*10,(([NUMBER OF DAYS TO BILL])*5))))

[Bruce]

That did it! Thanks!