Count() for Dates

[Guest]

Good morning,

I have a date field and a Count() field on my form. The Count() field will
count the number of records of the date field being populated by the users on
the form.

I use the formula "Count([Date Field])", and it does not seem to work. For
example, I have 10 records on the form. If I enter a date on one of 10
records, the count field would show 1.

Thanks.

 

[Guest]

fields with Null values are excluded in the Count function.

 

[John W. Vinson]

Good morning,

I have a date field and a Count() field on my form. The Count() field will
count the number of records of the date field being populated by the users on
the form.

I use the formula "Count([Date Field])", and it does not seem to work. For
example, I have 10 records on the form. If I enter a date on one of 10
records, the count field would show 1.

Thanks.

You're misunderstanding. Count does not count dates. It counts Records, in the
query in which you're using it. If you have Count([any field name]) or
Count(*) as just a calculated field in a query, the result will be 1 - that
very record.

It's not clear what you want to count. Do you want to count all of the records
in the table upon which the form is based? All of the records entered by this
user? all of the records entered by THIS user on THIS form during this
session? If so, what's the recordsource for the form?


John W. Vinson [MVP]

 

[Guest]

Thanks both of you for your responses.

I want the count field to count the records of populated date fields. When
the users enter a date in that date field on a form, it should count as 1.

Now I think it's working. For some reason, it wasn't working when I posted
the message.

Thanks again.

Good morning,

I have a date field and a Count() field on my form. The Count() field will
count the number of records of the date field being populated by the users on
the form.

I use the formula "Count([Date Field])", and it does not seem to work. For
example, I have 10 records on the form. If I enter a date on one of 10
records, the count field would show 1.

Thanks.

You're misunderstanding. Count does not count dates. It counts Records, in the
query in which you're using it. If you have Count([any field name]) or
Count(*) as just a calculated field in a query, the result will be 1 - that
very record.

It's not clear what you want to count. Do you want to count all of the records
in the table upon which the form is based? All of the records entered by this
user? all of the records entered by THIS user on THIS form during this
session? If so, what's the recordsource for the form?


John W. Vinson [MVP]

 

[Guest]

Count([Date Field])",

=Count("*","RecordSetName","[Date Field] Is Not Null")

--
Dave Hargis, Microsoft Access MVP

Thanks both of you for your responses.

I want the count field to count the records of populated date fields. When
the users enter a date in that date field on a form, it should count as 1.

Now I think it's working. For some reason, it wasn't working when I posted
the message.

Thanks again.

Good morning,

I have a date field and a Count() field on my form. The Count() field will
count the number of records of the date field being populated by the users on
the form.

I use the formula "Count([Date Field])", and it does not seem to work. For
example, I have 10 records on the form. If I enter a date on one of 10
records, the count field would show 1.

Thanks.

You're misunderstanding. Count does not count dates. It counts Records, in the
query in which you're using it. If you have Count([any field name]) or
Count(*) as just a calculated field in a query, the result will be 1 - that
very record.

It's not clear what you want to count. Do you want to count all of the records
in the table upon which the form is based? All of the records entered by this
user? all of the records entered by THIS user on THIS form during this
session? If so, what's the recordsource for the form?


John W. Vinson [MVP]

 

[John W. Vinson]

Count([Date Field])",

=Count("*","RecordSetName","[Date Field] Is Not Null")

Typo there, Dave? I think that should be =DCount("*", ...

John W. Vinson [MVP]