I am not an expert user of Access. I am trying to Union two Tables but I am looking to pull columns from one table that is not part of table 2. Is there a way to do this.
Table 1
Field 1 Field 2 Field 3 Field 4
data data data data
data data data data
data data data data
Table 2
Field 1 Field 2...