Make table query

[zogpound]

I want to make a single table from several tables that contain essentially the same fields, Problem is I want all fields and all the data in the tables. Access seems to only accept parts of the data. Is there a way to accomplish this?

Thanks, Eric

 

[IfButOnly]

An APPEND query might do what you want.

 

[gblack]

Union Query

Or a UNION Query...often I find this is the best way, since append query is an action query...meaning if your tables get new data in them, the append query wont automatically reflect that.

Can you write SQL code? If so I think the UNION query is best.

If not.... check out some examples of a union query...its not very tough to figure out

 

[zogpound]

The UNION query looks like it will do the trick. I found an example and it doesn't look to difficult. My question is where do you actually write the SQL in Access for the query?

 

[gblack]

When you make a query...do not chose a table...then go to the query section of the menu bar and choose UNION QUERY. It will pull up the SQL Page...

Another way is: in the design view in the left hand corner, you should see the data sheet symbol with a drop down arrow beside it. if you click the drop down arrow, you will see where you can choose SQL.

My suggestion is choose the first table you want with all the fields. then click the SQL button. That starts the code off for you. Access goes a bit crazy by specifying the [tablename].[fieldname] for everything. You don't need to do that, but its a start at least