G
Guest
I would like to combine several access tables into one access table and then
utilize a search function in order to look up specific data
utilize a search function in order to look up specific data
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
To combine them (assuming they have identical structures) you could use
append queries to add records to the table you wish to save from the ones
you will delete.
If you only wish to combine the data for the purpose of performing a search
(if you will not be deleting the tables) then you should not create a new
table, but rather create a union query which combines several tables' data
into one group of records that can be used in forms or reports, or can be
evaluated further. The query wizard will help you create a union query.
Rick B
append queries to add records to the table you wish to save from the ones
you will delete.
If you only wish to combine the data for the purpose of performing a search
(if you will not be deleting the tables) then you should not create a new
table, but rather create a union query which combines several tables' data
into one group of records that can be used in forms or reports, or can be
evaluated further. The query wizard will help you create a union query.
Rick B
P
PC Datasheet
Don't combine your tables! Use an Union Query. Look up Union Query in Help
file.
file.
R
Rick B
I'm sorry, the wizrd does not do it. If you decide you want to create a
union query, I believe it can only be done in SQL.
Here is an article on how to build a union query.
http://support.microsoft.com/default.aspx?scid=kb;en-us;209062
Rick B
union query, I believe it can only be done in SQL.
Here is an article on how to build a union query.
http://support.microsoft.com/default.aspx?scid=kb;en-us;209062
Rick B
G
Guest
Thank you for the help! I have about 10 tables with only about 5 column
headings for data in each table. The article you referred me to says how to
join 2 tables in the query. Do you know if you can join that many tables in a
query an how it is done? Also, the data comprising the 10 tables is being
updated all day long. Will the query reflect this updated data?
headings for data in each table. The article you referred me to says how to
join 2 tables in the query. Do you know if you can join that many tables in a
query an how it is done? Also, the data comprising the 10 tables is being
updated all day long. Will the query reflect this updated data?
G
Guest
Thank you for the help! I have about 10 tables with only about 5 column
headings for data in each table. Do you know if you can join that many
tables in a query an how it is done? Also, the data comprising the 10 tables
is being updated all day long. Will the query reflect this updated data?
headings for data in each table. Do you know if you can join that many
tables in a query an how it is done? Also, the data comprising the 10 tables
is being updated all day long. Will the query reflect this updated data?
R
Rick B
Why don't you try it and see. Have you read the articles (or the help
file)? Have you tried to build one?
Help your self and THEN ask us if you need more help.
Rick B
file)? Have you tried to build one?
Help your self and THEN ask us if you need more help.
Rick B
P
PC Datasheet
<< know if you can join that many tables in a query >>
Yes
<< how it is done>>
Look up union queries in Help file
<<Will the query reflect this updated data>>
It will reflect the data that is in the table at the time the Union Query is
run.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Yes
<< how it is done>>
Look up union queries in Help file
<<Will the query reflect this updated data>>
It will reflect the data that is in the table at the time the Union Query is
run.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com