LibreOffice Base - Group 11

Queries Part 4

We first see how to limit the number of records in our result set, then see the distinct feature, we calculate the weekly and annual salary, then we look at how to create a constant value in our output.

We look at how to create a query to search for a specific employee ID. Then we apply the same principles for a date range query.

We add wildcards to our user input query and use it to create a simple form with a user input parameter.

Function in design view - How to count up the number of records on a table or for a result set - We can also group by a field (like department) and count or summarize a numeric field by group.