I have a quick Access question. I have a subform with a field that counts the number of records with =Count(*). What I would like to do is exclude some people from that count, ones who have a 'Yes' in the the field "Cancelled". Is this possible easily? (If it isn't, I don't need anyone to spend a lot of time on it)

THanks

I have a quick Access question. I have a subform with a field that counts the number of records with =Count(*). What I would like to do is exclude some people from that count, ones who have a 'Yes' in the the field "Cancelled". Is this possible easily? (If it isn't, I don't need anyone to spend a lot of time on it)

Yeah, it's simple. Say the subform has the recordsource "myQuery", then you could use the DCount like this:

=dCount("*","myQuery","Cancelled=Yes")

Assuming Cancelled is a binary field. If it's a text field, put the 'Yes' inside single quotes.

Is that what you wanted?

Thanks! It is exactly what I wanted!

Oh- Except for the record source is (I think) an SQL statement that is SELECT DISTINCT ROW [Studentsandclasses]-- does that make a difference?

No. Just put the SQL statement inside the quotes where the query/table name would otherwise go.

Thanks!

Just as an aside, every time is see "mySQL" my brain goes "My So-Called Life."

Sheep that I am, I just signed up for a Twitter account. Anyone have one of these and actually use it?

Jess, I do, and then I knew like two people and forgot to ever look at it again.

I've got one but I never bother with it really.