[AccessD] Append Query

Stephen Bond stephen at bondsoftware.co.nz
Tue Jul 20 03:48:49 CDT 2004


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 



More information about the AccessD mailing list