Cosmiccradle
Technical User
I'd like to know if it's possible to count up letters like one does numbers. I have a list of magazines and newspapers in one of the columns I use a letter code as to the frequency it appears. For instance "M" for month, "W" for weekly "F" for once every fourteen days etc. What I want is to have an formule at the end of the report as to how many monthly and weekly etc. products are in possession. Is this possible?
I placed the post wrongly and have recieved the following answer
Since it's on a report (there is a report forum, Forum703), add the needed number of controls to the report footer, and as controlsource use something like this:
=abs(sum([LetterCode]="M"))
LetterCode being the fieldname.
Roy-Vidar
Your example is only "M" how do I include "D", "W", "V", "S", and "K" in your example? Does anyone know how I include the rest of the letters. Or do I need to make a single formule for each letter?
Thankyou for your time.
I placed the post wrongly and have recieved the following answer
Since it's on a report (there is a report forum, Forum703), add the needed number of controls to the report footer, and as controlsource use something like this:
=abs(sum([LetterCode]="M"))
LetterCode being the fieldname.
Roy-Vidar
Your example is only "M" how do I include "D", "W", "V", "S", and "K" in your example? Does anyone know how I include the rest of the letters. Or do I need to make a single formule for each letter?
Thankyou for your time.