total_to_date

[site]

Hello,

I try to compute Total_to_date.

eg: FIELDS:

FINES DATE
$200.00 8/2/01
$300.00 8/6/01
$600.00 8/7/01
... ...

I want to create subform for total fines that means when I select date(8/6/01), the subform total_fines needs show up for $500.00.

Can help me out how to write this query to expree for "total fines to date".

Many Thanks.
Jing

 

[jtmach]

Try this...

SELECT IIf([DATE]<[What Date?],1,0) AS boolDate, Sum[FINES] AS [SumOfFINES] FROM [FIELDS] GROUP BY IIf([DATE]<[What Date?],1,0) HAVING (((IIf([DATE]<[What Date?],1,0))=1));

You will have to fill in the names of stuff yourself but this is generally what you want to do. The hardest questions always have the easiest answers.