Populating a new field based on another field

[sarahji]

Hi all,

I just merged two tables into one, and I want to add a field that distinguishes records from the first table and the second one. So I want the new field to have one value for all records with primary keys lower than X and another value for those above X.

Eg:


New field: VisitType
For primary keys 1 - 473325: value will be "Survey"
For primary keys 473326 - 534582: value will be "Complaint"

Any suggestions on how to do this?

Thanks!

[pbaldy]

Try an update query:

UPDATE TableName
SET VisitType = IIf(KeyFieldName < 473326, "Survey", "Complaint")

[sarahji]

Success! Thanks, Paul!

[pbaldy]

Happy to help!