Conditional Sum in Group Footer

[mckenneyj]

I have been trying to figure out the following scenario. Hopefully you can help.
Access 2002

LEADS table has many fields the ones in question are
ContractAmount Currency
RegionalManager Text
ApptDate Date
DFTDate Date


Report runs for range of [apptdate] Between [begindate] and [enddate]
Grouped weekly on RegionalManager
Displays various totals on other fields in the RegionalManager footer

Now I need a conditional sum of the constructionamount where dftdate is null
This is also in the footer

 

[dawnd3]

Try looking up the DSUM function in the help menu. I think this will get you what you need. If you need help with the function, post again. Dawn

http://www.calliopeconsulting.net