I have a problem with data manipulation when grouping records on a date range.
Each record has a date and a time, (they are cash receipts linked to a cash register). Of course I have multiple records per day.
I want to group these records by day and verify the data via another table (the cash register verification table).
To group my records on a date range I have no problem (I used formulas of type DATETIME_FORMAT(Date, "DD/MM/YYYY ")).
On the other hand I want to use the sum of each day and link this sum in another table of my database and I can’t do it with the rollup because it considers the records unique and not grouped.
In short, on the one hand I have customers who buy, and on the other hand I want to do a data validation on the totals of several columns per day and this without having to link via a rollup each record of each customer.
Thanks for your help.