I'm trying to build a summary query, using the design tool. But if I put a GROUP function on a field, then run the query, Open Office crashes.
I've looked for documentation on how to use GROUP (GroupBy), but haven't found anything that explains what I'm doing wrong.
FWIW, here's an example of what I'm trying to do.
Code: Select all
ID Type Date
01 AA 01/02/2020
01 AA 01/03/2020
01 AA 01/04/2020
01 BB 01/05/2020
02 AA 01/02/2020
02 BB 01/05/2020
I put a GROUP on the ID field and on the Type field, but crash-a-roni.
Thoughts?