Query Count and Max don't appear to be providing the intended results-Prob Me

[Miskondukt]

Lo again all,



I have a query that I am trying to identify the largest "version no" of either a quote/order and also the "counts" of version numbers (To validate the max). I have attached three screen shots showing the query and results.

The max version for the boxed item should be "3" and the count should also be "3", but that's not what the query is producing.

Ideas?







Ty kindly

[Miskondukt]

I do have 16 rows of 'invoices' from the linked GL table, but they are not "quotes" but invoices referencing the quote/order number.

[John_G]

I do have 16 rows of 'invoices' from the linked GL table, but they are not "quotes" but invoices referencing the quote/order number.

And those are the rows that it is counting. The query without the Group By would have one row for each of those invoices, which means the Version No. occurs 16 times. They are all the same because they are coming from the same record in the Quotes n Orders table, but there are still 16 of them.


A solution would be to create another query based on the GL Billing table, which will have the sum of the (Post Amount??) values for each order. Then, in the query above, link to that secondary query instead of the original GL Billing table. There will be only one record in that secondary query for each order.