Doing an Access Query with 2 tables,
Table 1-Agency_Claims contains user, agency, codes (up to 3 codes per user)
Table 2-CLAIM_CODES contains the code & descriptions with fields agency, code, code description.
Need to create a query that contains the descriptions next to each code. My attempt (attached file shows results) ends up displaying the first code's description for all three codes for each client.
Made multiple adjustments with the joins - and didn't resolve.
Tried using criteria on the NAME field to indicate if agency_claims.code=claim_codes.code_type. that didn't work either
How can I get User, Agency Code1 CodeNAME (for code1), Code2 CodeNAME (for code2), Code3 CodeNAME (for code3) to display?
Bookmarks