countif on tables

[Chris]

How would I input in a field a formula that automatically counts the number
of say yesses in the previous fields of the same table? What I'm essentially
looking for is something like what the Excel application can do with
spreadsheet format where i can count the number of yesses or noes in
preceeding columns of the same table?

 

[Duane Hookom]

If you want a table to behave like Excel, you might want to link it in to
Excel and add your calculated cells.

If you want to keep your application in Access, create a totals query or
form with totals or report with totals.

 

[Susan Gleason]

If the field you're talking about is in an Access report, you probably want
to use the DCount function.

 

[Susan Gleason]

But for a calculated total in a form or report, what you're looking for is
DCount.

 

[Duane Hookom]

You should rarely use DCount() in a form or report header or footer section.
Count() and Sum() are much more efficient.

 

[Duane Hookom]

DCount() might be necessary but in 99% of the reports I have created the
calculation that I want to display in my report is based on the records
displayed in my report. 99% of those needs are met by Count() or Sum(). I
can't remember using DCount() or DSum() in a report.

Maybe you can describe a normal situation where you have had to resort to
using DCount()?