Results 1 to 3 of 3

Thread: Help with query

  1. #1
    Join Date
    Feb 2005
    Posts
    4

    Unanswered: Help with query

    I have a table containing the following fields:

    [Rate1], [Years1], [Rate2], [Years2], [Rate3], [Years3]

    where the tables starting with "Rate" contain interest rates applicable for a # of years as found in the corresponding "Years" field.

    Take the following record, for example:
    5%, 2, 6%, 3, 5.5%, 1

    I need a query that will produce the following as output:

    5%, 5%, 6%, 6%, 6%, 5.5%

    This is just an 6 year example... In reality, I am dealing with 100 years.

    Much appreciated!

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    That's clear as mud!

  3. #3
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404
    I'm with poliarci on this one. If you're performing any calculations with rate and year you're surely not going to produce a % as the answer?

    ;-(

Posting Permissions

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