merging 3 query into a table

[zigomushy]

hi,
i'm trying to merge the content of 3 querys into a new table. but it just doesn't seem to work, or more precisly, i havn't got a clue how. any help would be of great use. thanks all.

Tim Fletcher
Netfactoriel.Com
Paris

[This message has been edited by zigomushy (edited 01-29-2002).]

 

[simongallop]

Create a query where the source are the 3 queries that you are trying to merge. Set up the query to show the information in the format that you want your table to be. Then in the menu bar click Query and select Make Table.

For the three queries, you will have to join them together (click on the field that links them and drag to relevant field in next query)

HTH

 

[zigomushy]

thanks for your reply. what i don't understand is that i haven't got a field to join the tree tables i just want the data from all three tables in one without having to just copy/cut.
sorry if the information keeps changing but i have only just realized what i'm realy trying to do.

 

[DougS]

You could create a "simple query", and in design view, right click and go to "add table", and from the list add all the tables or queries that have the info you want to display, then simply drag each filed from the tables or queries one at a time into your new query in the order you want them to be displayed, and have a look at "datasheet view" to check that all the info you want is there and is displayed properly.

 

[zigomushy]

thanks for the tip on Union, it might be what i'm looking for.
but i still don't think that it is the answer.
imagine 3 tables (but that are actualy querys):

client1
client2
client3

all three tables contain unique info (same data but different value ie. name, surname ...)

is there perhaps a way to create a VB routine that would, one after the other merge the three tables into one.

i realy do appreciate all the feed back from you all

--{corected for typo error}--

[This message has been edited by zigomushy (edited 01-30-2002).]

 

[Rich]

You need to restructure your db. You don't need seperate tables for each client. Have a look at some of the samples supplied by MS or even some created by the db wizard to see how this is done.
HTH