Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    126

    Unanswered: using an update query to update records from another query

    this is my sql:

    UPDATE tblDepoActivityTable SET tblDepoActivityTable.ActivityDate = [qryDateMax]![MaxOfDate/Time]
    WHERE (((tblDepoActivityTable.ActivityDate) Is Null));
    Im trying to update the date thats in qrydatemax into tbldepoactivitytables activitydate field. Is this possible? The date in the query is the max value and only shows one record.

  2. #2
    Join Date
    Aug 2012
    Posts
    126
    can close mods, i found a work around

Posting Permissions

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