Summarising data when criteria is met only

[mous]

Hello There

I have a report whereby I have a start date and fields that contains figures. I only want to summarise these figures when the date is after a today's date. Is this possible?

Can I use something like Sum if on my report?

Thanks

Dawn

 

[yellow]

Not sure if this is what you are after but.....

If you put the sum calculations on your report in an immediate if.

For example:

IIF([Enter Date:]>date(),Sum Calculation in here,"")

Hope this helps. Look up IIF in Access Help.