Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 616
  • Last Modified:

Correct syntax for DCOUNT expression with duel boolean conditions

Hi,
I've got an unbound textbox in a form with a dcount expression in it as the control source.
The result I want is a count if 2 different yes/no fields are both ticked.
The control source expression is as follows, but it keeps giving an error message in the textbox. Also, the textbox flashes (like it is stuck in a loop).
As you might guess, I'm a bit new to this (I've been looking on the net, but can't find a similar example to guide me).
field1 is text, field2 and filed3 are logical (yes/no) fields
Hope you can help.
Bill

=DCount("[field1]","table1","[field2]=True and [field3]=True")

Open in new window

0
Billw1100
Asked:
Billw1100
1 Solution
 
peter57rCommented:
Looks fine to me.
Make sure everything is spelled correctly
0
 
Billw1100Author Commented:
I feel like an idiot. When I first read your answer, I thought "of course my spelling is correct - its the first thing I checked". But I was wrong of course. I had mixed up the control's Name and Control Source for one of the fields. Thanks for your help. It works correctly now.
Bill
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now