Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    214

    Unanswered: Report Qtr Total

    Hi all. I have a Report in Access 2003 that includes months and their total. I would like to get a total for the qtr months only. ex. January 1000 February 329 March 873 etc. I am using a query for the recordsource for the report but don't want to put the criterion in the query because I want to get all the months. In the text box control source I put:
    =Sum([SumofHrs](IIf([MTH] Between "1" And "2",0))). This returns an error stating SumofHrs undefined. When I put the parenthesis around it and insert an & sign, it gives me a total of all months. ex. =Sum([SumofHrs]) & (IIf([MTH] Between "1" And "2",0)). I just want the first three months. Can anyone help

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Sample Reporting

    If it helps, here's a neat little reporting form for reports. It has extensive date selection buttons on the form.
    Attached Files Attached Files
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Sep 2006
    Posts
    265
    This is an how I calculate ageing:

    Age150: Sum(IIf(Now()-[Client Sale Date] Between 150 And 180,[Local Amt]-[Local Pay],0))

    Simon

Posting Permissions

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