Count function 1

[ptrifile]

I have a report that is run from a basic query. The report will show a persons name and can have up to 8 dates that are separate fields. I simply want to have a count for each persons name of how many of the 8 "date" fields are populated and not count ones that are blank or null.

Hope this makes sense....any help is appreciated.

Thank you.

Paul

 

[dhookom]

Eight date fields doesn't make much sense to me since it doesn't seem normalized. However, you might be able to use an expression like:
=8+(IsNull([DateOne])+IsNull([DateTwo])+IsNull([DateThree])+IsNull([DateFour])+IsNull([DateFive])+IsNull([DateSix])+IsNull([DateSeven])+IsNull([DateEight]))

Duane
Hook'D on Access
MS Access MVP

 

[ptrifile]

Dhookom, thank you that worked perfectly!!!!!

The reason for 8 date fields is if a tech calls in sick we have to record the number of jobs that had to be rescheduled for that individual.

Thank you again!

 

[dhookom]

Your reason doesn't make much sense to me but I hope it does to you.

Duane
Hook'D on Access
MS Access MVP