Hi Duane,
This is what is mentioned in the query:=
Current: (Date())
Diff: Sum([Current]-[Date])
Days 0-30: IIf([Diff]<=30,Sum([Balance]),0)
Days 31-60: IIf(([Diff]>=31 And [diff]<=60),Sum([Balance]),0)
I need that Current :(Date()) to be open : Some thing like Parameter, on entering through Parameter the calculation should take place and query must run.
Thanks,
Shekar
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> 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@...
> >
> > 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 (4) |
Tidak ada komentar:
Posting Komentar