Trying to find a way to create monthly data auto

[waymond]

I have a situation where the client only enters data once a month, but I need to store the data into a table for reports or a query. my tables are follows
ORG name of table
OrgID field
AuxName field

AuxDetailTable
OrgID field
MonthEndDate field
Raised field (money raised this month)
Disbursed field (money disbursed this month)

One of my dilemas is that on some reports they need what total was carried over from the previous month then they would key in this months raised money and disbursed money to come up with new total.

Thank You

 

[IGPCS]

in the table add a date or month field and then you can create a query in these fields where the information of current month is = to what the client entered in there or include the currnetmonth - 1