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
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
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 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.