Hi,

I wish to combine three tables into one. Please help

Thanks!
Boss

Hi,
you can either use append query and put data into 1 table, or use UNION
query for get data from all 3 tables like:
select field1 from table1
union
select field1 from table2
union
select field1 from table3

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"Boss" <(E-Mail Removed)> wrote in message
news:C574DDAA-06C5-4E9C-9B6B-(E-Mail Removed)...
> Hi,
>
> I wish to combine three tables into one. Please help
>
> Thanks!
> Boss