Update query same field multiple criteria

[nad341]

Hi,
I need to update the periodtype field in my table depending on different values in the field Formtype- I am looking to do this without having to use VBA. I have the following fields in a table - I want to update the value of the field Period_type as follows -

When Formtype is 10-Q, update Periodtype to "Quarterly"
When Formtype is 10-K, update Periodtype to "Annual"

The current value of Periodtype for both formtypes is "Semiannual"

Can I do this using only update query?

Thanks
NAD

 

[bob fitz]

You can certainly do this using two update quieres.
Backup you data.
Then try:
When Formtype is 10-Q, update Periodtype to "Quarterly"
Use:

UPDATE [COLOR=red][B]YourTableName[/B][/COLOR] SET [B][COLOR=#ff0000]YourTableName[/COLOR][/B] .Periodtype = "Quarterly"
WHERE ((([B][COLOR=#ff0000]YourTableName[/COLOR][/B] .Formtype)="10-Q"));

When Formtype is 10-K, update Periodtype to "Annual"
Use:

UPDATE [B][COLOR=#ff0000]YourTableName[/COLOR][/B] SET [B][COLOR=#ff0000]YourTableName[/COLOR][/B] .Periodtype = "Annual"
WHERE ((([B][COLOR=#ff0000]YourTableName[/COLOR][/B] .Formtype)="10-K"));

You will need to change: YourTableName

 

[nad341]

Hi Bob,
Thanks for your reply. Very helpful.