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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sums on a report 1
Help with LEFT Function 2
Creating a report 5
Please Help! 4
error in running total querry 1
Account for null values on a report 2
access 2003 filter a report 2
Sum If on Report 10

Back
Top