IF statements

[astrevens]

Nice simple one but i cant get me head round it.
What i want to do is IF the field [pr_Discount]=Y then add 30% to the field [pr_Cost]. All this in one query if poss

 

[AlexMidd]

Do an update query with criteria set for the pr_Discount field to "Y" and the Update to box for the pr_Cost field set to [pr_Cost]*1.3 Have fun! )

Alex Middleton

 

[AlexMidd]

BTW, the SQL for this query would be:

UPDATE Table1 SET Table1.pr_Cost = [pr_Cost]*1.3
WHERE (((Table1.pr_Discount)=True));
Have fun! )

Alex Middleton