Cant Change the data Type of calculated Field

[k31453]

Hi i got Gross Income Query

But i have employees that have overtime rate as well

So i have to calculate using overtime Payment And Gross Income Seperately

So i make query and in query

I write this equation

Ovetime Pay: IIf([Total Hours Worked]>[Normal Hours/week],([Total Hours Worked]-[Normal Hours/week])*[Overtime Payrate],"0")

I successfully calculate it ...

BUT IT JUST GIVE ME THE VALUE LIKE A NUMBER SUCH AS e.g. 50 ,150 but instead of that i want currency data type of that calculate field for e.g. 50 become "$ 50".

You know what i mean yeah???

Okay so in able to do that i go to properties Sheet of the field of the query and change Format to Currency ..BUT IT DOESN'T CHANGE !!!

i tried a lot to figure it out but cant able to ...

So does anybody know how can u do that?
View attachment dATABASE PAYROLL - Copy.zip

 

[jdraw]

You can try this (but it's only a guess)

Ovetime Pay: Format(IIf([Total Hours Worked]>[Normal Hours/week],([Total Hours Worked]-[Normal Hours/week])*[Overtime Payrate],"0"),Currency)

 

[k31453]

yeah i will try