S
swarfmaker
Access 2003
I have a subform, formatted as Continuous Forms, where I have the following
controls.
CourseTitle (TextBox)
Length (TextBox formatted as Integer)
Core (Check Box)
Withdrawn (Check Box)
All this works OK, showing the correct information.
I need to sum [Length] Where [Core]=True and [Withdrawn]=False in a control
in the Footer of the subform.
I've tried SUM([Length] Where [Core]=True and [Withdrawn]=False) but get
#Name
Can someone point me in the right direction
TIA
Iain
I have a subform, formatted as Continuous Forms, where I have the following
controls.
CourseTitle (TextBox)
Length (TextBox formatted as Integer)
Core (Check Box)
Withdrawn (Check Box)
All this works OK, showing the correct information.
I need to sum [Length] Where [Core]=True and [Withdrawn]=False in a control
in the Footer of the subform.
I've tried SUM([Length] Where [Core]=True and [Withdrawn]=False) but get
#Name
Can someone point me in the right direction
TIA
Iain