By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,254 Members | 2,386 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,254 IT Pros & Developers. It's quick & easy.

Access IIf statement

P: 28

I have a query in access that takes information from one application and imports it into another.

It imports product sales. In the application that it takes the information from two of the products are Butane and ISO-Butane but in the other application they are both just Butane.

I need to write an IIf statement that, if the product is equal to ISO-Butane it will change it to Butane and if it is any other product it will leave it as it is.

Your help would be much appriciated.

Jul 26 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,206
Do you want to do an update query?

Something like this:
Expand|Select|Wrap|Line Numbers
  1. UPDATE tblProducts SET productName = 'Butane'
  2. WHERE productName = 'ISO-Butane'
This would look in the table tblProducts and change any products with the name ISO-Butane to just Butane.
Jul 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.