469,648 Members | 1,536 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

Creating a "union" query between two tables?!

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
Nov 13 '05 #1
1 7400
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Marek Lewczyk | last post: by
9 posts views Thread by (Pete Cresswell) | last post: by
2 posts views Thread by BerkshireGuy | last post: by
5 posts views Thread by BillCo | last post: by
7 posts views Thread by php_mysql_beginer911 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.