Access Count function?

[Turnip12]

Figured it out, this can be deleted.

[howste]

I don't think you can do it in a query, but I think you can in a form or a report. If I remember correctly you can do summaries of data and have Access calculate totals.

With a query, I think about all you can do is filter out the records without the box checked. You can then see how many records are displayed, which would give you the count. If you're automating this with VBA, I think you could do the query and do some kind of record count function. Unfortunately I don't have time today to play with it.

[howste]

Doh! Ok, how did you do it?

[Turnip12]

I switched my table data types over to number from yes/no and it started displaying a value of -1 or 0 instead of yes or no, then I used the sum function in my expressions in my query to total up the value and used abs to switch it to a positive number. So not exactly what I was looking for, but it came out with the same result.

[howste]

Sounds like a good solution. I couldn't get it to sum up the True/False either even though it stores it as -1 and 0.

[vass0922]

Please don't delete the initial post, now we don't know what the initial problem is. If somebody in the future has a similar problem they can't use your thread to help them.

Unfortunately I don't think you can COUNT in sql server either because that requires a GROUP BY statement, and you can't group by a bit column