countif on tables

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

Guest

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?
 
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.
 
If the field you're talking about is in an Access report, you probably want
to use the DCount function.
 
You should rarely use DCount() in a form or report header or footer section.
Count() and Sum() are much more efficient.
 
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()?
 
Back
Top