Criteria statement 1

[assessor]

My tables contain data on real property sales.

In the Criteria Section I am constantly having to change the Sale Date range Between [Date] and [Date] to reflect the beginning and ending sale date range.

How can I set the ending Sale Date range to reflect the current date-without having to change it everytime I need to check for sales ?

 

[tlbroadbent]

Use date() as the criteria. Date() function returns the current date. You can use Date()+6 to represent a date 6 days in the future.

Example criteria:

WHERE TblDate Betweeen Date() And Date()+6 Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous