tables

L

loi

Hi,
I have 4 tables (They have same fields) in my database. I
would like to put all information into 1 table.

Please show me how.

I have tried to use copy and past, but it did't work.

I recieved the message "The value you entered itsn't
valid for this fiel."

Thank you

Loi
 
J

JimmyC

You can use append queries for each table , or you can make a union query, read posts on Combining Tables with my name on it below
 

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

List all tables, including document structure 0
How to have two tables on same line? 1
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Some mail merge fields not pulling into document 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Macro to copy table of contents to a new doc 0
VB Script reference cells for in current table? 1
Create a dynamic master file 1

Top