iif

I want to create a new table in MS Access 2007, based on 2 other tables. Table A has all the data. However, where table A and table B have the same value (specifically field12), I want to replace that value with the number "2". I thought the criteria would be something like: =IIf([Numerics...

Probably not exactly what you thought when seeing the thread title... I already evaluate a whole bunch of stuff from collections etc. Then I get to do the update query. strsql = "UPDATE [work] SET status = 'not required', updated = " & clng(int(now())) & ", archive...

Hello, I am trying to figure out the best way to get information out of an OLAP database. So the database is structured with these fields: [player], [team], [location], [points], [year]. There are many players which roll up into teams and many teams. There are 2 available years...

I have this: select iif(very long iif statement) as order_number, mid([a],1,2) as larry,more items from ... group by iif(very long iif statement), mid([a],1,2) I get invalid procedure call If I change it to select iif(very long iif statement) as order_number, mid([a],1,2) as larry,more...

Hi Guys, I want to do this: iif([POP] = 1 OR 2 OR 3,[POP]+1,[POP]) When I wrote it like that, it just added 1 to everything - even if the POP wasn't 1,2,or 3. What am I doing wrong? :(