Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group after the UNION

Status
Not open for further replies.
tpbjr

tpbjr

MIS
Oct 8, 2004
120
US
Hi All,

I have two group by queries that use the UNION to join them.

Here is my problem...

I have three fields that I do not want to be duplicated.
I want the two records (one from one side of the join and the other from the other side of the join) to role into one record that sums/totals the quantity and amounts.

The original UNION works but I just think I need to some how make that a sub query of an outer group by so it some how can get the duplicates (three fields) into one record.

Any ideas, maybe a generic template to get me started.

Do you need the actual query to help me?
Do you understand what I am asking?

Thank you for all your help

Tom
 
Status
Not open for further replies.

Similar threads

deeptic
  • Locked
  • Question
Displaying Date & Time when the form is run
Replies
1
Views
105
sem
sem
taqmeena
  • Locked
  • Question
Accessing Cursor Values in All over the Form
Replies
0
Views
98
taqmeena
taqmeena
WP
  • Locked
  • Question
Continue after error in script 1
Replies
3
Views
57
WP
WP
latha9
  • Locked
  • Question
nested group function
Replies
0
Views
52
latha9
latha9
meridian99
  • Locked
  • Question
what record is the cursor on
Replies
1
Views
87
BJCooperIT
BJCooperIT

Part and Inventory Search

Sponsor

Back
Top