Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Update Query in Access (https://www.askmehelpdesk.com/showthread.php?t=1646)

  • Apr 29, 2003, 09:25 AM
    lebboy
    Update Query in Access
    Hi there! How can I update different records differently in one field based on different criteria? Can I use the update query for that? Do I have to use a macro? Thanks for the help!
  • Jul 11, 2005, 12:26 PM
    JenVW
    Use a conditional expression :

    IIF(Criteria 1 is true), Criteria 1 response, Criteria 2 response

    Jen

    • All times are GMT -7. The time now is 05:32 PM.