I am using LibreOffice Base 7.4 to build a database and I am trying to get a report that uses the Accumulate function in a Group Footer to show the total of a particular field in the detail
When I run the report I find that some groups have a total and others the field is blank
This appears to be related to different values in the “Type” field
Is it the SQL the report uses that is causing this?
I have uploaded my ODB file for reference
Events DEV.odb (31.8 KB)