RodneyJ
Last Activity: Nov 19 '17, 02:55 PM
Joined: Nov 18 '17
Location:
-
RodneyJ replied to How do I match up to 6 fields from 2 or more tables and only return values that matchin AccessThank you NeoPa and yes I agree with your design comment. -
RodneyJ started a topic How do I match up to 6 fields from 2 or more tables and only return values that matchin AccessHow do I match up to 6 fields from 2 or more tables and only return values that match
In Access 2010 - I have saved 4 tables with identical fields. I am looking for criteria to match:
Job Number and Size 1 and Sch 1 and Size 2 and Sch 2 and description.
All must match to have a unique value. There will be many of the same values in all fields, but only when these values are combined I get a "unique" value or inventory part in this case.
At this point I have combined all 6 fields into...
No activity results to display
Leave a comment: