In spite of a Base and Access user, I'm totally lost with Kexi !
How to do a query to count data , for instance :
I need many queries by YEAR , like
1) YEAR , FIELD1
How to do it ?
Also , I need
2) YEAR, FIELD1, between DATE1 to DATE2
3) DATE1 < DATE2
Again, a very useful handbook, will be great, including special tips, like these !
I would like to help to write one !

@newtonnickel Moved to Kexi Help as this is not a news/discussion topic.

newtonnickel wrote:In spite of a Base and Access user, I'm totally lost with Kexi !
How to do a query to count data , for instance :
I need many queries by YEAR , like
1) YEAR , FIELD1
How to do it ?
Also , I need
2) YEAR, FIELD1, between DATE1 to DATE2
3) DATE1 < DATE2

When you have time I recommend browsing through the Kexi Help subforum as there are many valuable topics covered. In particular Querying by date range is explained. Do not hesitate to ask for explanation if something is insufficiently explained.

newtonnickel wrote:Again, a very useful handbook, will be great, including special tips, like these !
I would like to help to write one !

Indeed, would be nice to see some contributor going over the forum and adding the good practices and tips to the Handbook.