Awesome Help, still confused
I think what you given will work eventually, after I figure out how to translate this in to the database. With that being said it is unclear to me, being quite the novice, on how to get the Array into a table. My Access 2007 skill are limited. Please provide any further clues that you can. All your is greatly appreciated.
PJMCCS63
Last Activity: Sep 4 '10, 12:23 AM
Joined: Sep 1 '10
Location:
-
PJMCCS63 started a topic Loop through a table and get a record for each date that fall between StartDT and Endin AccessLoop through a table and get a record for each date that fall between StartDT and End
My table holds all personnel which need to exempted from training
For Example:
Exempted Table
Name, Exempted Reason, StartDT, EndDT
Smith, J, Reassign to X Dept, 3/1/2010, 7/30/2010
Jones, B, Extended Leave, 5/15/2010, 6/15/2010
So I would want a New Table to look like the following
Exempted Revised
Name, ExemptedMonth
Smith, J., 3
Smith, J., 4
Smith, J.,...
No activity results to display
Leave a comment: