Access Access

[terri2743]

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?

 

[Flona2012]

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??