Addtion of 2 fields in query

[Vanita]

1. Add 2 fields in a query, the calculated field should include all the records from each field(Which are from 2 different tables ).


2. After writing LEFT JOIN, the result includes all the records from Left table and in the other table it considers the data which matches with left table only.
3. Our requirement is, the result should include record if it exists in either of the table.

how to solve this?

[NoellaG]

Hi, if you can upgrade your back-end databases to SQL server (express version is free to download), you can simply use a full outer join to get the result you want. I don't know if this is available in Access though.

[alansidman]

Sounds like a homework assignment. Please confirm.