Recent content by neetzie52

In my employee's database, I have a data table with static info - Service date (when they started) and a table with leave time used. Here's the info for years of service -- YrsSvc: DateDiff("yyyy",[ServDate],[tblLeave]![date]) Then I have a query based on the YrsSvc query to calculate their...

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

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

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

I have a report that needs a grand total. Every report has a link to the location #. Main report is personnel info-type of employee, pay, total hours, and total pay. First subreport is equipment info-type, rate, total $. Second subreport is materials-type, cost, total $. Third subreport is...