Total group / sum bug? (1 Viewer)

Tskutnik

Registered User.
Local time
Today, 10:34
Joined
Sep 15, 2012
Messages
229
Thanks. Let me come back to this a little later today
Really appreciate the time
 

Tskutnik

Registered User.
Local time
Today, 10:34
Joined
Sep 15, 2012
Messages
229
All - for the sake of the project I'm working on I figured it out.
I rewrote some of the queries and changed a bit of clunky logic and it works now.
I still have the same basic question that I cant get past. How can a query produce a value but when Totals/Sum does the aggregation the values are zeroed? Even with my underlying clunky logic once the un-totaled query is created the Totaled query should give the same result and not zero values out.

Thanks all for the input. I'm always amazed how helpful everyone is with other peoples projects.
 

isladogs

MVP / VIP
Local time
Today, 14:34
Joined
Jan 14, 2017
Messages
18,186
Glad you have a solution and I think it was a good idea to go back and review what you had done so far.
Out of interest, was the query I supplied in post #20 OK?
 

Users who are viewing this thread

Top Bottom