Shekar,
You could create a table with a single field [AsOfDate] and a single record which would store the date. Add this table to your record source and replace Date() with AsOfDate.
This query will not be updateable.
Duane Hookom MVP
MS Access
----------------------------------------
> From: tchshekar@yahoo.com
>
> Hi
>
> I am looking for ageing query say 0-30, 31-60, and so on, but the problem is The Now()date / Today() should be replaced with a date which should be at our discretion, and as required.
>
> i.e we should be able to generate report on any Past date.
>
> Thanks
>
> Shekar
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar