Search results

You are absolutely not helpful, and very condescending.

I know that, but i'm not the only user of this database, so I have to take into account that others using this database may need to see the information (though it's redundant) to help with their data entry. The file id is a string of characters and numbers that are not easy to make sense of, so...

Maybe "shared field" is a misnomer. What I mean to say is the table "Download_Log" and table "Data_QC" (the table that Data_QC_Form is based off of) have fields that are equal. So File_Name in the first table and File_Name in the second table should be equal, and I would like File_name in the...

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...

how do I tell if my attachment came through??:banghead:

Here's some sample data...the workbook has 3 tabs corresponding to the tblHVAC, tblHVACaddidata, and what tblHVAC looks like after I run the query. I hope the attachment works right...

Well, I tried it both ways...and I even added the fields to the tblHVAC (the table I am trying to add data to). It didn't merge the tables but instead just added all the data from the second table (tblHVACaddidata) to the end of the first table...which is not what I need. What am I missing?

I changed the query to a select query: SELECT tblHVACaddidata.* FROM tblHVAC LEFT JOIN tblHVACaddidata ON (tblHVAC.[Item] = tblHVACaddidata.[Item]) AND (tblHVAC.[Site ID] = tblHVACaddidata.[Site ID]); And had no problem running the query. There's no reference to the district field in the SQL...

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] =...