Conditional summing of values

[Huck_M]

I have created a report from a query that includes an equipment "start up
date" and an "estimated days" required for equipment startup. The query and
report includes all equipment that has shipped but has not been started. I
can accurately sum the "estimated days" for the entire report, but I also
need to calculate the "estimated days" on only the equipment has a "start up
date" 90 days from the current date. Can anyone provide any guidance?

 

[Duane Hookom]

You can create conditional sums with expressions like:
=Sum(Abs({true/fals expression}) * {Expression To Sum})
For instance if you want to sum the sales for Mondays, you would use:
=Sum(Abs(Weekday([SaleDate])=2) * [UnitPrice]*[Quantity])