Access 03 Field Update

[ddw23]

Hello and Happy New Year to All!

I have 2 tables:

T1: Price File main fields (cate 1, cate 2, NIGP code) when received from vendor, NIGP codes are not entered and has many identical cate 1 and cate 2 fields because of the category of the items. Other fields distinguish the difference.

T2: NIGP Codes main fields (cate 1, cate 2, NIGP code) used to update the T1's NIGP codes.

Both tables have identical info in the cate 1 and cate 2 fields. Only T2 has NIGP codes.

I need for T1 to search T2 where cate 1 and cate 2 equal and update T1 with the NIGP code in T2.
I've tried an update query but it appears that my problem is the number of rows where cate 1 and cate 2 are identical. It should return 128 rows and it's returning 385 rows. I need it to find the first instance of cate 1 & cate 2 and update T1's NIGP field.

Yes, we are still using Access 2003 . Our IT department won't let us upgrade and convert our databases for whatever reason(s).
Thank you to all who can help me with this issue!

[Micron]

In the query you joined related fields and that's what you got? If so, more info is needed - like data samples from both tables. The joins (or lack of) could be the problem. Or not enough conditions like AND. I recommend using Excel to create sample data, complete with column headers. If sized properly, a copy & paste into your post makes a quick and well formatted table.

[ranman256]

1 you don't have to upgrade.
2. The 'first instance' is relative. If you have a date field,or some other criteria to determine the first.
make a query to pull the most recent record.
then make an update query to fix the data from Q1.