Sums on a report

[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?

 

[Marshall Barton]

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?

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.