Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland, Canada
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    create new table

    I need to apply percentages to a record, based on a master table. Then I need to create a new record for each percentage.
    The initial query to create percentages works fine. One record amount becomes four amounts. How do I create a new record, in a new table presumably, for each of the four amounts, while retaining the initial field descriptor? Essentially, I need a record1A, record1B, record1C, etc.

    Any help would be appreciated.

    Ang[img]/w3timages/icons/dragon.gif[/img]

  2. #2
    Star Lounger
    Join Date
    Apr 2002
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make Table Query?

    If your query contains the data you need in the record couldn't you just change it to a make table query?

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland, Canada
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make Table Query?

    I tried that, but I need a separate record for each amount. For instance, $100 is split into three amounts - 50, 40 and 10. Each of these amounts needs to retain its other fields, but be a separate record which will be further processed.
    Thanks for the reply, though

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make Table Query?

    Are any of these criteria static. That is to say, is it always a 3 way split of 50/40/10 ? Or do the number of splits and the percentages vary for each record?

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland, Canada
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make Table Query?

    Thanks for the reply, Brian. The percentages are obtained from one table, the total from another, and are combined to create the splits. So, no, the percentages are not static.

  6. #6
    Star Lounger
    Join Date
    Apr 2002
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Four Append Queries Then?

    It may be the long way around (I always manage to take the "scenic route") - but how about four append queries then?

    Each is basically the same except the final piece they append.

    Append Query 1: Basic Data & %1
    Append Query 2: Basic Data & %2
    Append Query 3: Basic Data & %3
    Append Query 4: Basic Data & %4

    You could set up a macro (or use code) to run the four queries with one command button push.

    Not the sleekest solution but may allow you to move forward.

  7. #7
    New Lounger
    Join Date
    Jan 2001
    Location
    Newfoundland, Canada
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Four Append Queries Then?

    That just might work, TexasTJ. I'll give it a try. Perhaps all singing, all dancing is not the way to go.

Posting Permissions

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