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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine a service table with an intake table 1
Question about Creating a Project for reporting only 4
Combine two unretlated linked tables 8
Combine data in two records from same field 16
trying to create a database, need help!!!!! 3
Relationships 1
Query: convert multiple logical fields into single 2 character text result 2
how can I make database for tracking income outcome? 1

Back
Top