View Single Post
  #2 (permalink)  
Old March 25th, 2008, 06:37 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Do you have the table structure behind this? I would think that with this sort of function you would want to have a table to hold this information. If you have a Trainer table, it would look like this:

tblTrainer
TrainerID - PK
LName
FName
...
Vested - Y/N

tblVesting
VestID - PK
TrainerID - FK
Year - Text
Points - Number
Vested - Y/N

Then I would store this data permanently instead of using a query to present the data. Can you post the structure?

HTH

Oh, anyway, you can do this with a series of queries, or with code.

mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote