Creating a "union" query between two tables?!

[CrystalDBA]

I usually design applications in SQL Server and Crystal Reports. I
now need to create a crystal report on an MS Access database.

I have two tables:

Services:
Date datetime
Entry text
Amount number
(should be 4 records)

Offerings:
Date datetime
Entry Text
Amount number
(should be 20 records)

In SQL Server, I would just create a union query and join the records
from Services and the records from Offerings to get one select
statement result with 24 records. For my Crystal report to work, I
don't want to have to make a table and then report off that table. I
would rather build a report on a query thereby making it dynamic.

I am fairly new to writing queries in Access and would like to know
how to do this in Access.

Thanks,

Tony

[Allen Browne]

Create a new query.
Change it to SQL View (View menu).
Key in the UNION ALL statement.

Access can't show union queries graphically, but that doesn't mean you can't
write the sql the way you wish.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"CrystalDBA" <tt******@hotmail.com> wrote in message
news:b0**************************@posting.google.c om...

I usually design applications in SQL Server and Crystal Reports. I
now need to create a crystal report on an MS Access database.

I have two tables:

Services:
Date datetime
Entry text
Amount number
(should be 4 records)

Offerings:
Date datetime
Entry Text
Amount number
(should be 20 records)

In SQL Server, I would just create a union query and join the records
from Services and the records from Offerings to get one select
statement result with 24 records. For my Crystal report to work, I
don't want to have to make a table and then report off that table. I
would rather build a report on a query thereby making it dynamic.

I am fairly new to writing queries in Access and would like to know
how to do this in Access.

Thanks,

Tony