Search results

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

Maybe there is a better way to accomplish what I am trying to do...PLEASE any suggestions would be great.

jdraw...you are correct...my ERP system generates a .txt file every 5 mins...it is our "open orders"...I take that text file and upload it in to a access table called "New"...I then want to "copy" the data from "New" to a table in Access called "Old"...I add a column to the "Old" table at the...

jdraw...I use the names New and Old because I am the only one messing with this database, and I do know what they are for...(plus I plan to rename eventually). So basically I have a text file (delimited comma)...that is generated by my internal ERP program (it is generated every 5 mins, it is a...

Hi all, I am a newbie with Access...but have been able to do a few things that have worked, but more that have not :banghead:...anyways, here is what I am trying to do. I have a table called "New" that imports data from a text file created by another program...I added a column to the end of the...