combining data from unrelated tabels

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

Guest

we are a treatment center with 3 types of clients. each type of client has a
seperate tabel as the data fields vary with the client type. we need to
create a statistical report including all of our clients including age of
clients served, gender, ethnicity, and family income. how do I combine the
data from the different client tabels into a single report?
 
Hi.

Create a Union Query on which to base your report. Access Help should give
you all the info you need on how to do this. Post back if you get stuck.

-Michael
 
Thanks! I've never heard of a Union Query. It took a couple tries to get the
syntax right, but it worked. Thanks so much for your help.

Sherrie
 
Back
Top