Stats

  • Thread starter open a adobe file from a command button
  • Start date
O

open a adobe file from a command button

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??
 
A

Arvin Meyer [MVP]

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"
 
Top