Subtotal Records

  • Thread starter Thread starter Debbie
  • Start date Start date
D

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
 
Debbie said:
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
Click to expand...

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)
 
Thanks, Marsh...that worked. I tried ifs and wheres and
just couldn't hit the syntax right...
-----Original Message-----
Debbie said:
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
Click to expand...

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)
Click to expand...
 
Back
Top