Counting the number of Dates and/or letters (Yes/No) in a column
My customer wants to count the number of dates and/or letters that he has put in a column. Wants to have the total number at the bottom of a column. Can this be done?
Yes, this can be done, but the devil is in the details.
Each row in this layout is a separate record?
IF this is your column of dates:
is the count supposed to be 4 (total number of dates) or 3 (total unique dates)?
When you count letters in the column, same question as above and: one letter only in each field or multiple letters in the same field?
Thanks for the info. Customer wants up to 30 separate unique dates (as 3/5/2011, 4/5/2011, 7/12/2011) as a list in one field (column). Also wants up to 30 separate Yes or No's in one long field (column). I didn't want to make 30 separate fields for these, since there are 12 headings across the top.
I don't think that's a good way to go here. I didn't suggest "30 separate fields", but rather 30 records with one date in each record. A list or table view of your data would then display this so that your 30 dates are all in one column. There are also ways to set up portals to organize data into columns with one date (or letter) in each record in the portal that can sometimes be useful.
Retrieving data ...