1. Home
  2. Client-Server SQL Database
  3. Client-Server SQL Database: Ad Hoc Where and Sort Fields Menu

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

Ad Hoc Where and Sort Fields Menu

Ad Hoc Where and Sort Fields menu

Optional context functions for AdHoc Where and Sort fields typicaly found in report selection windows.

Line

Function

Keys

Insert Column 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

 

See also: –

Compiled in Program Version 5.10. Help data last modified 7 Jan 2015 09:03:00.00. Class mAdHocWhereSort last modified 18 Feb 2015 01:54:08.

Updated on May 27, 2020

Was this article helpful?

Related Articles

Leave a Comment