Search results

  1. D

    Update a field based on value from another table

    Hello all, I need help with my form. I have a table called "Download_Log", where data received is logged into this table and assigned an identifier called "File_ID." Once this file is QC'd, the user will go to a form called "Data_QC_Form", select the File_ID from a combo box based on a query...
  2. D

    Help with append query please!!

    Hello all, I have 2 tables I want to join. I want to merge them on 2 fields: tblHVAC.[Site ID] = tblHVACaddidata.[Site ID] tblHVAC.Item = tblHVACaddidata.Item Below is my SQL code: INSERT INTO tblHVAC SELECT tblHVACaddidata.* FROM tblHVAC LEFT JOIN tblHVACaddidata ON (tblHVAC.[Item] =...
Back
Top Bottom