Search results
-
D
Solved Grouping within a group or grouping DLIST, is it possible?
Thx. Too much trouble. I will stick with the Dutch months (close to English anyway) -
D
Solved Grouping within a group or grouping DLIST, is it possible?
Thx all! I wil bookmark this page in case the performance drops and I have to normalise the table. But momentarily the query works within 2 seconds. The solution of Eberhard worked, with all in the same query. However, and that is also anoying in my other VBA issues, that the locale setting of... -
D
Solved Grouping within a group or grouping DLIST, is it possible?
I have a table with 300k records containing the following data (sample) Id p_year p_month code 59901 2024 02 820996 59902 2024 01 5721012 59903 2024 02 826193 59904 2024 01 820139 59905 2024 02 821012 59906 2024 01 821032 59907... -
D
Using group, sum, first and last in a query
I have a database with the following records +--------------+------------+-------------+---------+ | period_start | period_end | customer_id | revenue | +--------------+------------+-------------+---------+ | 1-1-2023 | 31-3-2023 | 1 | 1000 | | 1-4-2023 | 30-06-2023 |...