Iif then statement needed for Access 2007 please

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

Hi all,
I'm trying to figure out how to write an Iif Then statement in access 2007
for:

iif columnZ = 10 then columnZ = A

please help, SQL and query table builder

Thanks
Heather
 
Heather

I'm not clear why you need to use an IIF() expression...

Have you looked into creating an update query? (CAUTION: backup before
running a query that alters your data!)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Below should work in a query.

IfZ10: IIf([columnZ] = 10, "A", [columnZ])

If columnZ is a text field, then you may need double quotes around the 10.
Also note that if columnZ isn't 10, it will return what is in columnZ instead.
 
Thanks for your replies, I've tried the following, but it didn't work?
ColumnZ is text, so I put the double quotes, but still to no avail?

Any ideas please
Heather

Jerry Whittle said:
Below should work in a query.

IfZ10: IIf([columnZ] = 10, "A", [columnZ])

If columnZ is a text field, then you may need double quotes around the 10.
Also note that if columnZ isn't 10, it will return what is in columnZ instead.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Heather said:
Hi all,
I'm trying to figure out how to write an Iif Then statement in access 2007
for:

iif columnZ = 10 then columnZ = A

please help, SQL and query table builder

Thanks
Heather
Click to expand...
Click to expand...
 
Hi Bonnie,

I'm trying to do it as an update query using the query design interface, I
don't even know where to begin with VBA or any scripting lanuage.

I've tried your suggestion, but it doesn't like this. The numbers remain as
10, not changed to A. I've tried it with the original column as text or as a
number, but to no avail!?
Thanks for your interest and help,
Heather
 
Thanks Bonnie,
but thats definetely what I did, and it didn't work?
Not sure what to try now...
Heather

bhicks11 via AccessMonster.com said:
Just to be sure:

While in the query design interface, click Query in the top menu, then click
Update Query. Make sure you have ColumnZ in the query. In the ColumnZ
column, CRITERIA row put "10", then in the UPDATE TO row, put "A". This
should work.

Bonnie
http://www.dataplus-svc.com
Hi Bonnie,

I'm trying to do it as an update query using the query design interface, I
don't even know where to begin with VBA or any scripting lanuage.

I've tried your suggestion, but it doesn't like this. The numbers remain as
10, not changed to A. I've tried it with the original column as text or as a
number, but to no avail!?
Thanks for your interest and help,
Heather
Are you doing this in an update query or in VBA?
Click to expand...
[quoted text clipped - 23 lines]
Thanks
Heather
Click to expand...
Click to expand...
Click to expand...
 
Back
Top