Unanswered: multiple updates to update a field in a table
Hi...I have a field expiration date in my table and the UPDATE query criteria differs for months 1-11 and the month 12 ...how can I run these 2 update queries for each of these criteria together in a single UPDATE query to update this expiration date field at one go...I tried using UNION to join these 2 UPDATE queries into one UPDATE query..can anyine help me please...
UPDATE Member SET Member.ExpirationDate = (PaymentMonth+1) & "/1/ " & DatePart("yyyy",Date())+1
UPDATE Member SET Member.ExpirationDate = "1/1/" & DatePart("yyyy",Date())+2
I hope this will help you understand my question better