Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Showing Totals in Report (Access 97 / Win.98)

    My knowledge of Acces is very minimal. I have taken several access classes, but don't get to use it often enough to apply & therefore remember what I learned in them. I will try to describe what I am trying to do for this particular project. Just let me know if more details are needed.

    I run a monthly report of returned goods for my empoyer. The report is grouped by Reason for return then by customer then by return date. The layout in design view is report header, pager header, reason header, customer header, detail, reason footer, page footer, report footer. The detail section lists the qty. of items returned among other things. I would like to display the total of items returned for each reason. I thought I could do this in the reason footer by creating a text box with =sum(QtyRet) in the control source. That didn't work. What am I doing wrong?

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Showing Totals in Report (Access 97 / Win.98)

    What is the field name in your table for the Quantity of items returned? It is this fieldname you need to put in the =Sum(...).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    New Lounger
    Join Date
    Oct 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Showing Totals in Report (Access 97 / Win.98)

    I think the field name is QtyRet or should it be more detailed than that? Does it need to tell which table/query as well?

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Showing Totals in Report (Access 97 / Win.98)

    You wrote:
    >>I think the field name is QtyRet or should it be more detailed than that? Does it need to tell which table/query as well?<<

    Well, you need to be sure of the field name. Another thing to check. Make sure you don't have a control on your report by the name of QtyRet. Change the control's name to something like txtQtyRet. It generally a good practice not to have your control name's the same as the controlsource fieldname.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    New Lounger
    Join Date
    Oct 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Showing Totals in Report (Access 97 / Win.98)

    Thank you. It's working now. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •