fb7894
06-09-2008, 07:49 PM
Is it possible to do a DCount on a the last character in a column?
Example: Suppose column A has the following data...
RGR
RARG
AGGR
GRAGA
I'd like to count the number of rows where the last character = R (The answer would be 2 in this example).
Example: Suppose column A has the following data...
RGR
RARG
AGGR
GRAGA
I'd like to count the number of rows where the last character = R (The answer would be 2 in this example).