Problem with calculation-monthly report

[neetzie52]

I've looked thru a lot of questions/answers and haven't found anything relating to my problem.

I keep track of employees sick & vacation time. They have a balance as of the first of the year, then a calulation to subtract time used, plus time accrued each month. So the report has a grouping by month but this calculation doesn't work because I don't need to keep adding in the balance every month. It should be based on the ending balance from January, carried over to February, etc. I've looked at this so much, I'm getting cross-eyed and very frustrated so I need help.

Thanks.......... Anita

 

[KenHigg]

How are your tables set up?

kh

 

[neetzie52]

Problem w/calculation-monthly report

Table 1 - employee list table
on report - emp ID, name, position, beginning Sick/Vac balances, service date
Table 2 - codes
on report - code, type of leave
Table 3 - data
on report - date, code, emp ID, hours

Created from query that calculates leave accrual amount

I'll try to send you pictures of what I'm talking about.

 

[KenHigg]

In the data table, do you have the means to credit accrued time.

Say they take a day, you do a data record to show -8, code 'vac'., etc. Do you do something like +80 on jan 1, with a 'credit' code?

???
ken

 

[neetzie52]

Problem fixed!

Ken - I tried to send you a message but your mailbox is full! You must help a lot of people.

Anyway IT WORKED!! Just wanted to thank you for your assist - it's great!

Sincerely, AS