LibreOffice Base - Group 10

Queries Part 3

We look at what Nulls are (The value in a field before anything is assigned to it) and the difference between Nulls and Empty (or no value ').

Instead of using Less Than and Greater Than we show how to use Between or NOT Between to create a selection filter range.

How to use IN and NOT IN to filter down our result set - Instead of Less Than and Greater Than