Client-Server SQL Database: Ad Hoc Where and Sort Fields Menu

Insert Column

Opens a column selection listing to allow insertion of an appropriate column name. This is the only menu items available both on Adhoc extra where fields and Adhoc pre-sort fields. Other lines are not available in Adhoc pre-sort fields.

Yesterday Only

For yesterday only.

Today Only

For today only.

Last 7 Days

The last 7 days to yesterday.

Last Week

Last week ending last Sunday.

Last 2 Weeks

Last 2 weeks ending last Sunday.

Last 4 Weeks

Last 4 weeks ending last Sunday.

This Month

From the start of the current month to today.

Last 6 Weeks

Last 6 weeks ending last Sunday.

Last Month

Last calendar month.

Last 3 Months

Last 3 calendar months.

This Year

This calendar year to today.

Last Year

Last calendar year.

Last 2 Years

Last 2 calendar years.

Last 5 Years

Last 5 calendar years

• – Introduction to Client-Server SQL