IFF statement

[Octet32]

I have a query in the RT field there are records that = 1111111 and 9999999
In LOC_No file I have counted the record that match Zip_codes, Company,RT
If any records = 1111111 and 9999999 I need them to be change to the
..LOC_NO that has the highest number.

SELECT Zip_codes, Company,RT, .LOC_NO
FROM Table1;

Can I write an iff statement that can do this?

new to acces can anyone help.

thank octet

 

[Jeff Boyce]

I'm a bit confused ... are you saying you have a field ("RT") that can
contain two values at once? If so, be aware that this is frowned on in good
database design.

I guess I don't understand either your data structure or your data example
well enough yet ...

More info, please...

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.

 

[Octet32]

I have a query in the RT field there are records that = 1111111 and 9999999
In LOC_No file I have counted the record that match Zip_codes, Company,RT
If any records = 1111111 and 9999999 I need them to be change to the
..LOC_NO that has the highest number. An = that RT




SELECT Zip_codes, Company,RT, .LOC_NO
FROM Table1;



Can I write an iff statement that can do this?

 

[Jeff Boyce]

Sorry, probably not enough caffeine yet today... I'm still not
understanding your data structure.

If you are trying to modify the values in a table, first make a backup or
two!

Then, take a look at Access HELP for "Update query".

Good luck!

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.

 

[EddieJ]

BTW, its not an IFF (typo) function but an IIf