Simple Query Question

[haydenal]

Say I have 2 tables both with a field [A] and a field . Can I do I simple query that basically appends [A] and from both tables (as opposed to an append query resulting in a new table)? What might the expression have to look like to do this?

 

[HiTechCoach]

Note:

* Append queries create new records in an existing table.
* Update queries change data in existing records.
* Make Table queries create a table and then appends new records.


Are you wanting to update existing record? Is yes, then use an Update query.

 

[haydenal]

I don't think I'm trying to do any of those things. I simply want to see a list of both fields in both tables in the same simple query (maybe an append query, but I don't want to necessarily create a new table). So, for example, if there are 5 records in table 1 and 5 records in table 2 my query would return all ten records.

Table 1
Field A Field B
1 A
2 B
3 C
4 D
5 E

Table 2
Field A Field B
6 A
7 B
8 C
9 D
10 E

Query1
Field A Field B
1 A
2 B
3 C
4 D
5 E
6 A
7 B
8 C
9 D
10 E

 

[HiTechCoach]

OK. Sounds like you want to combine the two tables into a single recordset. If this is true, then you need to use a UNION query to combine the two select queries.

 

[haydenal]

That led me to where I want to be. Thank you!