[AccessD] Append Query

Hi Stephen

This sounds like a clean job for a Union query:

  Select * From qdyInter
  Union All
  Select * From qyyIntra;

/gustav


> Results of an election come in two forms, paper and electronic.  One table for each.  There are 2 fields in each table, the VoterId and the vote (Yes/No).  A couple of queries have culled out the
> duplicate voters intra- and inter-.  The output of these queries therefore consists of a list of clean electronic votes and a list of clean paper votes.  

> I want to take these two output and merge them into one list without using the Maketable/Append approach.  I want the list to be a *query* output.

> Any ideas?  I didn't design this scenario, I've been asked along at party's end ....

> Stephen Bond