Sums on a report

  • Thread starter Thread starter Natasha Bennett
  • Start date Start date
N

Natasha Bennett

Hello,

I have a field called "Loan types" in my main table. Each
loan type has the word "conv, fha, or va" to indicate
which general catergory it falls into.[For example: Conv
30yr, FHA 30yr, HZ100 Conv, FHA 15yr, VA 30yr, VA Arm.]
When I group by loan type, it group on each individual
type and not the general catergory. Is it possible to
group according to the general catergory, which is only a
partial string of characters, so I can get a summary of
all CONV, FHA, VA Loans?
 
Natasha said:
I have a field called "Loan types" in my main table. Each
loan type has the word "conv, fha, or va" to indicate
which general catergory it falls into.[For example: Conv
30yr, FHA 30yr, HZ100 Conv, FHA 15yr, VA 30yr, VA Arm.]
When I group by loan type, it group on each individual
type and not the general catergory. Is it possible to
group according to the general catergory, which is only a
partial string of characters, so I can get a summary of
all CONV, FHA, VA Loans?
Click to expand...


Should be stored in the table in two separate fields, but
since it's not, you'll have to group on an expression that
splits it out:

=Left([Loan Types], InStr([Loan Types], " ") - 1)

Just make sure you never have a loan type without a space.
 
Back
Top