Merging five queries (1 Viewer)

[amunafc]

Dear Guruz

I have attache my simple database. What I want is to create one query i.e. a union or anything that can put all the information from the five tables together. After that I want to design a simple report containing all the information from those different tables.

Yours

Amuna

 

[CBrighton]

How do the tables relate to each other? Which fields do you want to link them on?

 

[amunafc]

hi
the tables here are getting the infor from a table called 'All Data' and I have a make table queries that comes up with those four tables

so here there is no any relationship

 

[CBrighton]

Without a relationship it is hard to relate the data from one table to another.

If you want meaningful data from 5 tables then you need to have a meaningful way to connect them.