Recent content by OldPete
-
O
An old table with old information, a flat file with new information and a query.
I'm reading about "append queries" -- anyone know if this is the right path to achieving my goal? -
O
An old table with old information, a flat file with new information and a query.
I want to update all the old records with new info plus insert the additional 216 records. Thank you for all your help! -
O
An old table with old information, a flat file with new information and a query.
Sorry I didn't give you more information. Yes. The flat file has an item ID file and yes, they are the same value. The only difference is that there are 1951 records in the old table and the flat file has 2167. But, for example, item #1000 is the same in both files (since the flat file was... -
O
An old table with old information, a flat file with new information and a query.
If you go to photobucket and search by user "funnypete" you'll see the image there in the first spot. :) -
O
An old table with old information, a flat file with new information and a query.
Beetle, thank you kindly for the reply! The old table has an "ItemID" field that is the key. The old table has the following fields: (Had a screen capture of the fields but system won't let me post it... let me know if I can get it to you another way (PM?) Of those fields, the ones that need... -
O
An old table with old information, a flat file with new information and a query.
Ok! I'm going to work hard to keep this organized, informational, and as short as possible. I have a table with product information. The table has 18 fields. Of those 18 fields, 7 fields contain information relevant to the flat file I'm going to discuss. The data on this table is 2 years...