Results 1 to 2 of 2

Thread: Repeating Records

  1. #1
    Join Date
    Jun 2005
    Posts
    12

    Repeating Records

    Hi,

    Not sure how to go about this. But say you have a table

    Table: Lifecycles

    Year | RepeatTime | Cost
    =====================
    2005 | 2 | 10
    2007 | 3 | 20

    The idea being that there is a cost of 10 that occurs in 2005 and repeats every 2 years. Any ideas on how to get a results table that would look like:

    Year | Total Cost
    =============
    2005 | 10
    2006 | 0
    2007 | 30
    2008 | 0
    2009 | 10
    2010 | 20

    (obviously a limit on the maximum year would need to be set or the query would never finish)

    Cheers

  2. #2
    Join Date
    Jun 2005
    Posts
    12
    Hi

    I have solved this now, so do not worry about answering

    Thanks

Posting Permissions

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