I had submitted a question and got an answer but was unable to retrieve it.

Here is my problem. I have a date field and an amount field. I want amounts to appear in the amount field when a certain condition is met. Such as, if the date is </=12/31/00 the amount in the amount field would be $90 and if the date is >/=01/01/01 then the amount would be $120. What would be the equation that I would use and would this equation be placed in my query under the amount field. I am new to these equations and would appreciate any help. Thanks in advance for any knowlege you could share with me.

Try an update query similar to this:

UPDATE tblTempDate2 SET tblTempDate2.amount = IIf([datex]>#12/15/2001#,120,90);

Thanks for your help!

sagehrer