- Joined
- Jun 3, 2011
- Messages
- 23
- Reaction score
- 1
Can you do a multiple update with multiple criteria in an update query?
I am trying to update a field in a table that will have different values depending on the two criteria filters IE If a vehicle type = Car and the Post Zone = SO update the Rate field to £1.15. If the vehicle type = MPV and the Post Zone = SO update the Rate field to £1.20 etc etc. Different Post Zones will have different Rates so there will be about 8 different rates.
I am trying to update a field in a table that will have different values depending on the two criteria filters IE If a vehicle type = Car and the Post Zone = SO update the Rate field to £1.15. If the vehicle type = MPV and the Post Zone = SO update the Rate field to £1.20 etc etc. Different Post Zones will have different Rates so there will be about 8 different rates.