Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    3

    Unanswered: Can we join 2 UPDATE queries in one ....

    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 together in a single UPDATE query to update this table at one go...I tried using UNION to join these 2 UPDATE statements into one UPDATE query..can anyine help me please...

    regards
    Sidhartha

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    There is no reason why your update cannot be conditional, using an IIF function, as in

    IIF(MONTH([ExpirationDate])=12,DoThis,DoThis)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •