Counting Specific Records within a Table

[Tempo]

Using Access 2010, I would like to count all check amounts greater than $50 within a table. So far I’ve used the expression

= DCount("[ChkAmt]","tblChecks","txtChkAmt > 50")

, but this expression results in “#Error”. I believe I may have a problem with the “Domain” part of the syntax. The Objects and Controls I’m using are: tblChecks (a Table); ChkAmt ( a Field); and txtChkAmt (a Text Box). I would appreciate any assistance with my issue. Thanks in advance.

[Rabbit]

Use the field in your database, not the control in your form.

[Tempo]

Hi Rabbit! Thanks for responding. I modified the expression to

=DCount("[ChkAmt]","tblChecks","[ChkAmt]>50")

and

=DCount("[ChkAmt]","tblChecks","[ChkAmt]">"50")

. In both instances the result was #Error. Does the solution have anything to do with whether or not I'm using brackets and quotes appropriately?.

I would have responded sooner, but was searching the site for issues the same as or similar to mine.

[Rabbit]

You have an extra double quote that popped out of nowhere. It wasn't in your original code.

[Tempo]

I was experimenting with different bracket and quote positions, but none of my combinations appear to work. Here's the last failed attempt:

=DCount("[ChkAmt]","tblChecks","[ChkAmt]>50")

[Mihail]

As far as I know, NO brackets are necessary in DCount function:

=DCount("ChkAmt","tblChecks","ChkAmt>50")

[Mihail]

Again, as far as I know, this structure is available for all D functions.

[Tempo]

You're absolutely correct, Mihail, brackets are necessary when numbers, spaces, or some other character is used in Object and Control names.

When you included the expression I sent I could clearly see my mistake. A small, but critical one at that. Are you ready? The domain is "tblCheck" not "tblChecks" .

There you are...problem resolved. Much thanks goes out to you and "Hats Off" to Rabbit as well. You guys are Great!