Search results

I'm trying to delete all the rows in one table when the supplier code is equal to the supplier code in another table? Can this easily be done?

The changes table is basically a testing table, where we can test different options that we want to test. They are transportation tables, so if we want to change a pick up time, or a pick up day for a certain supplier, we do it in the "changes table" or testing table. Once we get all of the...

I have two tables (Base Table and Changes Table) with identical fields and field names. All records in the "changes table" need to be moved over to the base table, and the same records within that base table that already exist need to be removed/replaced. I have a field called "supplier...

Ok, i'm going to give the table structure you originally suggested another go. I tried it first, and it seem like I got right back to where I was some how. As I said up front, Access is not my strongpoint for sure. I appreciate your continued assistance with this issue of mine. You'be been a...

Sorry for being so unclear. I'm not usually the guy who works on this stuff. Our main guy is out for a while. See the example attached here, and let me know if that makes more sense?

The intermediate route/s are already added (if necessary) by the time i get the table. Someone else does that manually There are intermediate routes depending on how many crossdocks the product travels through. If it travels through one cross dock, there is no intermediate route (just a p/u...

I posted the other day and received helpful feedback, however I still cant get the query to do what I need it to do. I have a table with the following columns (Pick Up Route, Intermediate Route, Intermediate Route 2, Delivery Route) The PU Route and Delivery Route will ALWAYS have a route...

Sorry, format should be readable now. Thanks. Any advice?

I have a table with the following info: Supplier.......Receiver.......... Cost............... PURotue........... IntRoute.......... Del Route ABC Inc....... Dubab ...........$44.00.............. P-355 ..............I-335 ..............D-15 I would like to know how to make a query that will add...