Results 1 to 9 of 9
  1. #1
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56

    General totals question

    Hello everyone! If you have read any of my previous posts you know I'm working on a database, and without the help of you guys i probably would have been fired by now. Ive designed a query to list all the approved loans for any given month. I have a field that shows how much the loan is for; we will call it loanAmount. What i am looking for is a way to display, on a page in my report, the grand total of loanAmount's for the month. I don't have anything else in the database that calculates that for me. Thanks in advance

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Create an aggregate query to sum your loans.

    Look at this link

    http://www.techonthenet.com/access/f...umeric/sum.php

  3. #3
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    Make a report based on all your records.
    Then open the report in design view and make a field in the report footer called fldGrandTotal
    then in that fields properties you put this code =Sum([LoanAmount])
    Assuming the field in the report is also named LoanAmount.

    greetz, Jeroen

  4. #4
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56
    Thanks guys i will look at both.

  5. #5
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56
    Here is what i entered into the footer. ="fldGrandTotal"=Sum([LoanAmount] <--- on the report it just prints all of that. I also tried +Sum, tried taking out the "fld". This is all within a text box. I can only get it to perform a total calculation when i put =Sum([LoanAmount]) into the unbound text box.

  6. #6
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065
    Since it's in the Report Footer use a Text box and put this in the Control Source ="Grand Total" & Sum([LoanAmount])

  7. #7
    JeroenMioch's Avatar
    JeroenMioch is offline Competent Performer
    Windows Vista Access 2003
    Join Date
    May 2012
    Location
    Den Haag, Netherlands
    Posts
    368
    Ahh i missed the part that you said "for this month"
    Well you can do two things :

    Filter records for this month, before you open the report (this way fldGrandTotal will give u what u want)
    or Query it. I think AlanSidman's link will explain that.

    My personal prefrence is to filter the records form based. and then (when desired) report the filtered records.
    Allthough this method gives you great flexability it is somewhat more complex.

    Ill point out the pro's for you :

    You can filter your records based on anything you want.
    So lets say i want to look at all records where the name resembles "John" i get :

    John
    Johnson

    when i want all records with the name "john" in it wich were made last year, your i fill out "01-01-2012" in the end date field.

    See where im going ?

    You can filter endless combinations of arguments.
    Then when ive filtered them, i press "report" and it gives me a report on the records ive selected. (and thus the fldGrandTotal will sum those records)

    You can look at AlanSidman's link, perhaps that will give you what you want the fast way.
    If you want to know more about the technique to filter records, tell me then ill walk u through it.

  8. #8
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56
    Thanks for the advice. My query is currently already filtering the data by month. Its working fine with listing just this months approved loans. Sorry i didnt put that part

  9. #9
    brownk is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    May 2012
    Location
    Evansville, IN
    Posts
    56
    Turns out what i needed was very simple. In my report footer i created a text box. In the unbound i put my expression Sum=([LoanAmount]) - then changed the properties to currency. In the bound text box i just put in what i wanted to name the field which was "Totals:". Moved them around a little to position them better and bada-bing; Reports lookin good.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. General Question
    By notadbadmin in forum Access
    Replies: 3
    Last Post: 08-03-2011, 08:03 PM
  2. General Database Question
    By Lorlai in forum Access
    Replies: 1
    Last Post: 06-23-2011, 05:00 PM
  3. General question about access
    By TEE in forum Access
    Replies: 2
    Last Post: 05-30-2011, 07:50 AM
  4. General question
    By dollygg in forum Access
    Replies: 7
    Last Post: 12-11-2009, 05:13 PM
  5. General Database question
    By xyzz in forum Access
    Replies: 3
    Last Post: 05-20-2009, 10:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums