By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Creating a "union" query between two tables?!

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.