I have 2 db's w/similar info - need to make query combining them

[scolivas]

Hi, I have 2 databases - ALdata & SPdata

I have 2 tables - vewDemoData (in ALData) & vewDemoDataSP in (SPData)

both of these tables are identical in design, only the records are diff.

I need to create a query that pulls data from both - and displays this data as if it were pulling from one table.

fields in the tables are:
RepID
RepName
Project Code
Store#
DemoDate

I have another table which would be the base table - of RepID's and thier info called tblAllAssigned.

so what I am looking to do is in a query have it look at tblAllAssigned - take the rep#'s and spit out from both sp & al all the project codes assigned to these people in one column...instead of a column for sp and a column for al.

I figure this is either very easy ...and is escaping me or it is above me. Any help right away would be most appreciated.

thanks!
Sophie

[FishVal]

Hi, Sophie.

Take a look at Access help topic "UNION operation".

Regards,
Fish