Is there an IF function in Access?

[bateman]

Hello All,

In Access 2000, is there something similar to the IF function in Excel?

I want to compare two fields in an Access table and give a true/false when they match. There are over 700,000 records in the table so it would be painstaking to export into Excel by dividing the table up.

Or is there a way to run some kind of an update query asking to update field 1 when field 2 and 5 match? I'm very new to Access so forgive me if my suggestion above is not even possible!

Any push in the right direction would be greatly appreciated!

 

[ceelly]

In access 97 there is a IIF function in the expression builder in the design query view... Under program flow..

Look I been thinking I don't beleive you need an IFF statement to update the values.. go into the query in design view change the query type to update... I am assuming you have the table in the query you whish to update. Drag the field you whish to update in a column in the design view then in the update row type the new value then in the Criteria row type the expression that must be true for the field to be updated. In your case say fields2 = field3.

 

[Abulafia]

If you are having to perform comparisons and do an update on the information you have mentioned then it is most likely that you have a flawed database structure and need to normalise your database.