Aggregate query loses aggregate (1 Viewer)

[ClaraBarton]

I have a query that groups transactions together by ID:

But when I use this query and add another table it loses its grouping:

What am I doing wrong? The addition table is left join.

 

[June7]

Not seeing any additional fields so no idea why.

Post the SQL statement and sample raw data could be helpful. Could provide db for analysis.

 

[arnelgp]

i am guessing it should be grouped on those 5 fields

 

[ClaraBarton]

the query I want is 2qryRegister. All the others feed into it. The problem is when I add the transaction totals. Is there a way I can get all that together?

 

[arnelgp]

see the query now in design view and datasheet view.

 

[June7]

arnel, why not post the SQL? I already have the db.

 

[arnelgp]

rnel, why not post the SQL? I already have the db

just link the 2 objects on those 4 or 5 fields.

 

[ClaraBarton]

Whoa! I did not know you could do that! THANK YOU so much!