Access: Tables and Query - TechRepublic
Question
August 14, 2007 at 10:48 AM
adr1817

Access: Tables and Query

by adr1817 . Updated 18 years, 11 months ago

Hi all,

I’m new in using Access 2003. trying to figure out how to update a file with duplicates. I have an existing file called TABLe and i have a new file to upload to the current file.
for example:

table1 field contains:
Partnum
Mfrnum
TYPE
Price

Partnum has 8 items with duplicate partnums but
diff TYPE.

How do i fix it in order to upload to the current file with no problem and also will include the duplicate partnums with diff TYPE?

Thanks for the help

This discussion is locked

All Comments