Subtotal Records

[Debbie]

I have a report that has a qty field and a date field.
What is the syntax I need to create a text box that will
subtotal only the quantities that are for today or in the
future?

ex.
Qty Date
4 9/23/03
9 10/25/03
8 11/01/03

Qty total = 17

 

[Marshall Barton]

I have a report that has a qty field and a date field.
What is the syntax I need to create a text box that will
subtotal only the quantities that are for today or in the
future?

ex.
Qty Date
4 9/23/03
9 10/25/03
8 11/01/03

Qty total = 17

In either the report or a group (but not a page)
header/footer, you can use a text box with an expression
like:

=Sum(IIf({Date] > Date(), Qty, 0)

 

[Debbie]

Thanks, Marsh...that worked. I tried ifs and wheres and
just couldn't hit the syntax right...

-----Original Message-----

I have a report that has a qty field and a date field.
What is the syntax I need to create a text box that will
subtotal only the quantities that are for today or in the
future?

ex.
Qty Date
4 9/23/03
9 10/25/03
8 11/01/03

Qty total = 17

In either the report or a group (but not a page)
header/footer, you can use a text box with an expression
like:

=Sum(IIf({Date] > Date(), Qty, 0)