combining data in access

's Computer Specifications

How do you combine data from more than one table in Access?

's Computer Specifications

Not sure what you are asking for, if you want to display records from two
identical tables, to display all the data combined as one table, then use
Union query
Check this link

http://www.databasedev.co.uk/union_query.html

==================================
If you just want to link two tables, check this link

http://www.databasedev.co.uk/query_joins.html

--
Good Luck
BS"D

"krmckeown" wrote:

> How do you combine data from more than one table in Access?

's Computer Specifications

Thanks, I believe this is what I need, now if I can figure out how to
actually perform the task...

"Ofer Cohen" wrote:

> Not sure what you are asking for, if you want to display records from two
> identical tables, to display all the data combined as one table, then use
> Union query
> Check this link
>
> http://www.databasedev.co.uk/union_query.html
>
> ==================================
> If you just want to link two tables, check this link
>
> http://www.databasedev.co.uk/query_joins.html
>
> --
> Good Luck
> BS"D
>
>
> "krmckeown" wrote:
>
> > How do you combine data from more than one table in Access?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help removing duplicate data/combining like data in report	=?Utf-8?B?UmlzaWtpbw==?=	Microsoft Access Reports	1	29th Mar 2007 03:24 PM
Combining Access Data Fields	redlabel	Windows XP	0	31st Mar 2006 06:43 PM
combining multiple rows of data into one single row of data	=?Utf-8?B?bXllcnNqbA==?=	Microsoft Excel Worksheet Functions	0	30th Mar 2006 10:39 PM
Access - Combining Data from rows	A Mackay	Microsoft Access Queries	1	16th Jul 2004 02:38 PM
Combining data from different saved documents in Access	=?Utf-8?B?VmVyc2FuaQ==?=	Microsoft Access	0	17th Nov 2003 05:06 PM