Recent content by deerhntr22

That was it minty......thank you...:):):)

Latest SQL.... SELECT OPENORD.CUSTOMER, OPENORD.TY, OPENORD.[DATE ENTERED], OPENORD.[DATE DUE], OPENORD.[SO#], OPENORD.LINE, OPENORD.[WO#], OPENORD.[PART#], OPENORD.UM, OPENORD.DESCRIPTION, OPENORD.[ORD QTY], OPENORD.POUNDS, OPENORD.[WO CMP/ALLOC], OPENORD.LATE, SHIPCOM.[Reason/Actual Ship...

That did no change...same error...I believe it has something to do with multiple LEFT JOINS...I was reading somewhere that they had to be "nested" in order for them to work in Access...but I am unfamiliar on how to do that.

SELECT OPENORD.CUSTOMER, OPENORD.TY, OPENORD.[DATE ENTERED], OPENORD.[DATE DUE], OPENORD.[SO#], OPENORD.LINE, OPENORD.[WO#], OPENORD.[PART#], OPENORD.UM, OPENORD.DESCRIPTION, OPENORD.[ORD QTY], OPENORD.POUNDS, OPENORD.[WO CMP/ALLOC], OPENORD.LATE, SHIPCOM.[Reason/Actual Ship Date] FROM OPENORD...

Still doesn't work...this is what I am trying..."two left joins" SELECT OPENORD.CUSTOMER, OPENORD.TY, OPENORD.[DATE ENTERED], OPENORD.[DATE DUE], OPENORD.[SO#], OPENORD.LINE, OPENORD.[WO#], OPENORD.[PART#], OPENORD.UM, OPENORD.DESCRIPTION, OPENORD.[ORD QTY], OPENORD.POUNDS, OPENORD.[WO...

I had the criteria listed twice at the end of the SQL statement...I fixed that... WHERE (((OPENORD.LATE)<6 Or (OPENORD.LATE) Is Null));

I changed the names of the Tables to reflect what they are... OPENORD = (ERP data for open orders) SHIPCOM = (COMMENTS) Here is the query with the "one" join that works unless there are multiple lines...then the comment shows for each line... SELECT OPENORD.CUSTOMER, OPENORD.TY, OPENORD.[DATE...

I did a test run of it as well...and I am good until I get to joining "two" fields... Right now I have one join property that shows all records from "New" (linked data from ERP text file) and only records from "SHIPCOM" (Table containing three fields...SO#, LINE, and COMMENTS) that are equal...

jdraw...right now the supervisor looks at a datagridview (DGV) in a VB program...he scrolls through the lines and adds his comments...when he hits the save button, the program stuffs the data into the "Old" table and creates the HTML file...next time the supervisor wants to make changes...he...

I like that idea Minty...again, I am a newbie with this side of the fence...I am a network guy :D...but I am learning. I think I got it...just put SO#, LINE, and COMMENTS in the "Old" table...and then link the "New" table with the "Old" and display it...???

Yes, it is on a LAN...we use Access as a database for different programs (if that is what you mean). A shortcut points to the html file...It is stored on a Public Drive... They could have read-only access, but they would get confused vs an html page...(I have no issue creating the html...

Are you part of CustomerService or Shipping? How does the ERP ytem get updated to show/extract changing data every 5 minutes? The ERP system queries our database every 5 mins and then creates a delimited text file with that data...(headers being first line) Does your data consist of Sales...

Sorry...meant to add the whole process as well.... 1. Upload .txt file into table called "New" (20 columns in all) 2. Copy data from "New" table into table called "Old" and add column called "Notes" 3. Save "Old" table off as HTML for other users to view. At this point...the .txt...

You could create a table to contain the text file. I do that. Import the data into that table. I do that. Run a query to alter the table and add a field Comment. I think I do this...explain further Now populate the Comment field How, with...

Unfortunately I have no access to the way the ERP text file is generated...so I can't modify it...I only have the ability to read it.... So I read it into a database table "New"...but the text file data is changing continuously...lines are being added/deleted each time the text file is created...