Microsoft Query

This is a separate application designed specifically to create database queries.
SELECT Database



Query Wizard

You can use the query wizard to design the exact query.
allows you to select the tables
columns
add any filters
as well as adding any sorting
how to join the tables



The most useful feature is the database filter
This limits the records to your exact criteria


You can create up to three criteria for any of the selected columns.
or / and if you have multiple criteria


Tables - default to the order they are defined in the database
You can specify up to 3 different sorts.




© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext