monthly subtotals help

Hello! i'm having problem in my access program, here it is

main form:
name date 1500 -->fields
arwin 1/2/2009 200 --> records

subform: monthlysubtotal
month year 1500-->fields
jan 2009 10000--> records
feb 2009 0
i was able to compute for the subtotal but i cannot displayed it in monthly subtotals because it continously add each record. what i want is that after jan. 31 the subtotal will be displayed in a monthlysubtotal and when feb 1 comes it should restart to zero until i enter a new record in the main form.

Thanks and kindly help me.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!