Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013

    Unanswered: Creating more records

    Hello Guys,

    I need some help with this confusion I'm having. I have a table called Table1. And Fields ID and Age. If the age is < 60 I need to send this over another table called Table2 where there are two more fields, Number and Level. The ID's who's age is under 60 should look like this in the other table:

    ID Age Number Level
    1 56 11 5
    1 56 12 6
    1 56 13 6
    1 56 14 7

    And there are multiple ID's in Table1. And I want every ID who's age below 60 to produce this on Table2. I'm not sure what is the best way to do this. Thanks

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    Q why do you want to send data to table 2

    Querys will do this for you

    some like

    Age_Query to show all records <60

    then then next query

    you can join the about query to table2 by the ID's

    think like this

    table are the bones
    query are the cloths differance views of the bones.

    if you have multiple ID's I think you have a little problem with your data (you need to get the data bones right first) how do tou do it now??
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Posting Permissions

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