Need exact query to compare two Access tables
Posted on 2006-06-01
I need to compare two tables containing alphanumeric part numbers - the main table in my database and a smaller table I imported. When the smaller table numbers exactly match the numbers in the main table, I need a checkbox in the main table checked. Here are the particulars:
Table A: "Inventory"
Table A field to compare with Table B's: "Mfg Part Number"
Table A field to check when the above field matches the one in Table B: "pic"
Table B: "picfiles"
Table B field to compare to above field Table A: "picnumbers"
Thats it - I need the exact query written out using my table and field names so I can just paste it in with no syntax errors - I'm not a programmer.
Thanks very much to anybody who can help