Stats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some stats that I want to display on a form but it took 4 queries to
get all the data. I want to display all the information on the one form.
Can this be done??
 
Assuming that the 4 queries have the same fields, you can combine them into
1 with a Union query:

Select * From Query1
Union
Select * From Query2
Union
Select * From Query3
Union
Select * From Query4

Then use the union query as the recordsource of the form. The form will not
be editable.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"open a adobe file from a command button"
 
Back
Top