Originally Posted by
June7
Yes, query Design View. Create the JOIN clause by establishing a link line between the tables. Click key field in one table, hold and drag to key field in other table. If you set up relationship in Relationships builder the query would automatically generate the link.
However, the reason for failure is probably the spaces in field names. Enclose in [], like: [Claim ID]. If you used the Designer, it should supply the [] for you.
Advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention. Also, do not use reserved words, like Name and Date, as names.
This is basic Access query design functionality. Search Access Help or web for more info.