Merging tables

[don]

Hi,

Im using Access 2003 and want to bring parts of two tables together,
They both list jobs and a date to be done by. Can I create a query
that will stack both lists together or do I have to go about this a
different way.

Many thanks for your help

Don

 

[John W. Vinson]

Hi,

Im using Access 2003 and want to bring parts of two tables together,
They both list jobs and a date to be done by. Can I create a query
that will stack both lists together or do I have to go about this a
different way.

Many thanks for your help

Don

A UNION query will do the trick here. See the Help topic for UNION - it's
pretty good; if you have problems post back.

If you have two tables of identical structure, consider combining them into
one (with an additional field to tell which is which); storing data in
tablenames is not good design.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[don]

A UNION query will do the trick here. See the Help topic for UNION - it's
pretty good; if you have problems post back.

If you have two tables of identical structure, consider combining them into
one (with an additional field to tell which is which); storing data in
tablenames is not good design.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

John thank you for reply. I will do as you suggest, although I tried
following a book and got lost a bit with it. I should of added
perhaps that my tables are in different databases, one that deals with
the maintenance of assets and one that responds to general maintenance
tasks, Ive linked the maintenance table into my assets database and
only want to do this so I can generate a report based on assets that
are due for maintenance and maintenance jobs that have a date
completed by.

If you can post anything further great, but will endeavour with help.

Many thanks

Don

 

[don]

A UNION query will do the trick here. See the Help topic for UNION - it's
pretty good; if you have problems post back.

If you have two tables of identical structure, consider combining them into
one (with an additional field to tell which is which); storing data in
tablenames is not good design.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

Thank you. Help section was much clearer than my book.

Don

 

[John W. Vinson]

John thank you for reply. I will do as you suggest, although I tried
following a book and got lost a bit with it. I should of added
perhaps that my tables are in different databases, one that deals with
the maintenance of assets and one that responds to general maintenance
tasks, Ive linked the maintenance table into my assets database and
only want to do this so I can generate a report based on assets that
are due for maintenance and maintenance jobs that have a date
completed by.

Sounds like these are in fact different "entity types" and having two tables
is appropriate. Glad the UNION query worked (at least so it seems).

Just wish more of the HELP file was as good as the topic on Unions!
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com