Problem with GROUP BY

[bbater]

System: Windows 10, LO 6.3.5.2 (x64), Firebird
Hi. I’m having strange problems with GROUP BY. I’m following an [online tutorial] Video 29. His query, which works:
.

But when I try to replicate with my table, I get an error:

Any help offered is welcome.

[bbater]

Link above didn’t work. This is it: LibreOffice: Base - Homepage

[Ratslinger]

Hello,

Not all functionality is set for using Firebird (especially concerning older videos)

Set the first column table name to (no table)

Best to use SQL instead of the graphic interface.

[bbater]

Wow! I’d never have thought of that. Thanks Ratslinger.