Dcount Help

[Huey462]

I have a table that lists a date when everyone was issued a piece of cold weather gear. I need to make a summary report to quickly tabulate how many of each item was given out.
Table: tblIEU
Field: GlovesCold1

The frustrating part is this looks like it should be straightforward but it is not.

Using the following page as a guideline I tried variations of
General: DLookup Usage Samples

=DCount("[GlovesCold1]",[Criteria]="data")
and
=DCount("[GlovesCold1]",[tblIEU],[Criteria]="*")

Neither of which work, either displaying #name, or a window prompting me to enter a value to search by.

Any help would be appreciated

 

[Norie]

The criteria and table should be in quotes,

=DCount("[GlovesCold1]","[tblIEU]","[Criteria]='data'")

and if you are using a wildcard you need to use Like.

=DCount("[GlovesCold1]","[tblIEU]","[Criteria] Like '*'")

 

[Huey462]

I truly appreciate the quick reply but I suspect that the way Access is looking at the data may be causing the issue. I've tried both of your suggestion and "#Error" keeps showing up on the screen. The fields contain a date value, so we can see when Johnny was given a pair of cold weather boots.

 

[Huey462]

We were both overthinking it
=DCount("[GlovesCold1]", "[tblIEU]")

 

[james_lankford]

misread thread title as

Donut help

excitedly clicked on thread only to be disappointed