Count fields that contain a date, but some don't

  • Thread starter Thread starter Dasin
  • Start date Start date
D

Dasin

Using Access 2003

I have fields in the table that if an inspection passes the inspector
puts the pass date in the PassDate field, if it fails then the fail
date is put in the FailedDate field and so on. I would like to count
the number of times that there is a date in the PassDate field,
FailDate field(separate count) and so on. Since these fields aren't
numbers I'm having a hard time and a search in this forum didn't
provide an answer.
Any help really appreciated.
Thanks,
James
 
Dasin said:
Using Access 2003

I have fields in the table that if an inspection passes the inspector
puts the pass date in the PassDate field, if it fails then the fail
date is put in the FailedDate field and so on. I would like to count
the number of times that there is a date in the PassDate field,
FailDate field(separate count) and so on. Since these fields aren't
numbers I'm having a hard time and a search in this forum didn't
provide an answer.
Any help really appreciated.
Thanks,
James
Click to expand...

Well dates are stored as numbers. That is if you used an Access date
data type. You should have null (or could it have a zero?) or a number
(note the numbers run from a minus number to a plus number so don't try the
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to list records that don't match 6
Distinct Count in Crosstab 1
Restricting counts with WHERE clause in report 2
Count and sum per month in a query 2
multiple counts, same calculated field, different parameters 6
Count multiple yes/no field in a query 4
Count number of changes 4
Counting Unduplicate in Fiscal Year 1

Back
Top