Sums on a Report

  • Thread starter Thread starter NATASHA
  • Start date Start date
N

NATASHA

Hello,

I have a field can "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, Conv 20yr, FHA 30yr, FHA 20yr etc.] When I group by
loan type, it group by each individual and not the general
catergory. Is it possible to group according to the
genearl catergory so that I can get a summary of all CONV,
FHA and VA loans?
 
Change the grouping to for instance the left 4 characters
of the loan type, i.e.,
Left([Loan Types],4)
That should do the trick.
Hope this helps
Fons
 
Back
Top