counting records that are true

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I've set up a database where I need to count the records where [eval1]=yes

This should count up those people who have submitted an evaluation. I'm
really stuck - is this done in a query (using if) or the report footer?

Anyone help please
 
The short answer to your question is that you could do so in a query, but
you might want to think about your data structure. It sounds like your
field name contains data "Eval1". Do you also have an "Eval2"? If so, your
data structure is flawed. you are creating a spreadsheet, but doing so in a
database application.

If you are interested, post the names of your tables and fields and we could
help you normalize the data. Normalizing the data will change the structure
so you want to do so before you go too far.
 
Back
Top