Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DCount

Status
Not open for further replies.
nike2000

nike2000

Technical User
Apr 1, 2003
61
GB
Hi there,
I have the following If Statement on a field in a continuous form.

=IIf([DatesChange]="Yes" Or [CreditEventsChange]="Yes" Or [RefEntityNameChange]="Yes" Or [RefObNameChange]="Yes" Or [ObCharacteristicsChange]="Yes" Or [ObCategoriesChange]="Yes" Or [DelObCategoriesChange]="Yes" Or [DelObCharacteristicsChange]="Yes","Yes","No")

I would like to be able to count the number of rows returned as 'Yes'.
Can I use the DCount funtion?
If I can how would it be written?
Thanks
Nike
 
Status
Not open for further replies.

Similar threads

StanJx
  • Locked
  • Question
DCount Multiple Criteria
Replies
3
Views
286
Andrzejek
Andrzejek
MightyRoo
  • Locked
  • Question
Help with proper syntax on dcount with and
Replies
2
Views
128
MightyRoo
MightyRoo
MightyRoo
  • Locked
  • Question
Help with proper syntax on dcount
Replies
3
Views
144
PHV
PHV
CharlieT302
  • Locked
  • Question
Dcount with multiple criteria 1
Replies
5
Views
698
PWise
PWise
crisis2007
  • Locked
  • Question
Checking for duplicates using DCount
Replies
1
Views
111
crisis2007
crisis2007

Part and Inventory Search

Sponsor

Back
Top