Access Access

Joined
Nov 9, 2012
Messages
1
Reaction score
0
I have an interesting dilema. I am building an Access Database. I have a table that contains numbers associated with individuals. These numbers are imported each month. Lets call it MainNumber. From MainNumber I must subtract an adjustment number (ADJNum). I need to subtract the accumulated ADJNum from the MainNumber at each evaluation. So in January the ADJNum might be 20, if in February there are 40 more, I need it to adjust 60 from Feb. If there are 5 more in March I need it to adjust 65 from March.

Any ideas?
 
let me get this stright, is the MainNumber and ADJNum and the individuals data are in one table??
does this table has month column? or date column??
 
Back
Top