Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Query field to get 1 years worth of totals - show total...

    I need to create a query or something that will look at a a date field and an amount field, then will calculate the amount field with all the entries of a past year.



    So like this is 2007, I have a field called Last Years Total I want that field to always be dynamic in that it is just running a query on the table to see what the sum of certain Totals Field from last year was.


    So if my records show Date Price Ship Total

    1/24/06 $5.00 $3.00 $8.00
    4/2/06 $10.00 $0.00 $10.00
    2/3/07 $25.00 $2.00 $27.00

    Then the for this vendor the Lastyears total would query up to $18.00

    Something like that :0)

    -Sam

  2. #2
    Join Date
    Mar 2007
    Posts
    2

    In addition...

    I failed to mention that I want it to automatically recognize what year it is, so if it's 2007, it knows that that field should show 2006 data. And when it turns 2008, it'll know to show 2007 totals. Without the user having to put in some date range.

    -Sam

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

Similar Threads

  1. Query - using Max Totals with Criteria
    By mslieder in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:02 AM
  2. Data won't show up in table field
    By texzen123 in forum Forms
    Replies: 3
    Last Post: 11-26-2009, 11:20 AM
  3. query date that is five years older than today
    By cpsummer in forum Queries
    Replies: 2
    Last Post: 09-26-2007, 02:31 PM
  4. Lookup or list field: how Do I not show all records
    By scott munkirs in forum Forms
    Replies: 4
    Last Post: 04-13-2006, 12:44 PM
  5. query - totals
    By mslieder in forum Access
    Replies: 0
    Last Post: 02-22-2006, 06:11 PM

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