Recent content by DaveG

Hope someone can assist as this has me going around in circles. frmClasses has a sub form called frmClassesSubform frmClassesSubform has in footer unbound text box called CountRecords containing =Count(IIf([bookedstatus]="Confirmed",0)) This produces a figure indicating how many people have...

All understood Bob, thanks for the extra info.

Thanks also Bob, that works also, both replies are producing the same end result :-)

Thanks DentTec for reply, sometimes you just need that voice of reason. Did try something like that before but I kept trying =SUM[ rather than =[ Cheers again Dave

Hi all, I'm trying to add the results together of two counts. My report has field for Attendance and within that field there are three possible options, Attended, Cancelled and DNA. For reporting purposes I need to have a total figure for Attended and one for DNA's, then one further that...

Cheers Jeanette, think you were right, I was letting DistinctRow get in my was. All sorted now. Thanks again Dave

Jeanette, thanks for the info and that link, very informative. My problems seems to be taking the count field from within Districtrow within the subform source and putting it into the main form. If this was a simple form and subform think it would have been easier as I've done it before, but...

Hi There, Currently using 2003 and have been altering the Classroom management database found here: (Oops can't post links) Okay its the standard Access 2003 template on their website On that page you can also see the form I'm currently working on and where my question relates to. You'll...