Microsoft Access IIF Statement

[ridsey]

Im working on an inventory database. I have a column that is used to show whether the products warranty is calculated monthly or yearly. Now im trying to using queries to create some reports of total and what not. I am using this statement in the query to calculate the yearly amount on monthly figures

NewCost: IIf([Y/M]="M",[Cost]=[Cost]*12,[Cost])

but anything with the M gives me a cost of $0.00,

just wondering what im missing in my statement

 

[ridsey]

Nevermind, was able to figure it out myself!