Results 1 to 2 of 2
  1. #1
    marksnwv is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Jun 2011
    Posts
    9

    Month totals and Year totals


    I am using Access 2002 and I am having problems getting a monthly and yearly total on a Report. My Report Has a Field called (NumWkd) and (DateWkd) The report information is taken from a query. In the reoprt footer I sum all of my data. The problem I am having is one total is for the current month. The second total is year to date. If I put BETWEEN (#06/01/2011#) AND (#06/30/2001#) as a criteria for DateWkd I only get June totals which is fine for the Monthly totals. When I try to get Yearly totals I can only get Junes totals. If I leave out the BETWEEN statement then I only get yearly totals and not monthly totals.I have only been using Access for a short period and I am an old man. Please be simple in your explanation if you are offering help.Thank you

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Have you got a sample database you can show (something with fake data) It's hard to give you direction without seeing the structure of a report, the data sources, the groups, headers, footers etc.

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

Similar Threads

  1. Totals Again
    By marksnwv in forum Reports
    Replies: 2
    Last Post: 08-05-2011, 12:17 PM
  2. Week Totals
    By Azyrus in forum Reports
    Replies: 2
    Last Post: 06-26-2011, 04:21 PM
  3. Reports - totals by month
    By mtpyra in forum Reports
    Replies: 1
    Last Post: 06-12-2011, 09:19 PM
  4. Help with a totals filter
    By deiniolj in forum Programming
    Replies: 11
    Last Post: 03-30-2011, 04:34 AM
  5. Expense Totals
    By Nosaj08 in forum Database Design
    Replies: 10
    Last Post: 05-06-2009, 11:35 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