Howdy, Stranger!

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


monthly subtotals help

daredevileddaredeviled Member Posts: 1
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.