Hi all,
Many of our reports are run weekly or monthly to present data for specific period of time. This selection criteria picks up a specified range of source codes but I still have to enter the date range when I run the report.
I want to hard code something like this:
Also this:
Is this possible?
Thanks in anticipation.
Trish @ ITA
Many of our reports are run weekly or monthly to present data for specific period of time. This selection criteria picks up a specified range of source codes but I still have to enter the date range when I run the report.
Code:
tblAccounts.AccountSource >= 'LP' and tblAccounts.AccountSource <= 'LZ' and tblAccounts.sourcechangeddate >= '<&From Source Date>' and tblAccounts.sourcechangeddate <= '<&Thru Source Date>' + ' 11:59:59 PM'
Code:
tblAccounts.sourcechangeddate >= TODAY - 7 DAYS and tblAccounts.sourcechangeddate <= TODAY + ' 11:59:59 PM'
Code:
tblAccounts.sourcechangeddate >= FIRST DAY OF LAST MONTH and tblAccounts.sourcechangeddate <= LAST DAY OF LAST MONTH + ' 11:59:59 PM'
Thanks in anticipation.
Trish @ ITA
Comment