I have a query which pulls records from Table A. I want to include a descriptive field in my query that only resides in Table B. How can I go about doing so?
Table B has two fields, the ID I want to match on and the description I want to display. But I need to parse and concatenate two fields from Table A to get the ID to match on, like so:
Mid([Field1],2,3) & [Field2]
I can't figure out what to do next however.
Table B has two fields, the ID I want to match on and the description I want to display. But I need to parse and concatenate two fields from Table A to get the ID to match on, like so:
Mid([Field1],2,3) & [Field2]
I can't figure out what to do next however.