Search results

There has to be an easier way to do what I want. The situation: 40+ Employee have their own list of Clients, Client Contacts, Client Email Address, Report Types, etc. Each day they have updates on each client. Time spent with them, updates given, notes, etc. What the most effective way to...

I have a form with a control "TypeCode," it's set to: =IIf(Year(Date())<=Year([date]),[qryVacation.TypeCode],"Other") So that if the date on the form is less than the current year, the control will return "Other" in the box. At the bottom of the form, I have a subtotal...

This works for the count, but then it doesn't add in the totals I've put in for the "dummy" employees. I'm calculating a "leftover" amount, that needs to be added to the other totals. All entries must have an employee number.

I have Two fields with DateWorked and EmployeeNumber. All I want to do is count the number of employees that worked on a specific date. In the employee numbers I have 4 dummy numbers that I don't want to count in my query (00001-00004), but will have entries almost each day. The rest are 5...

I have a form based on a query. The query take entries from a table on sums them.... not a problem. Now I make the form, and I want to use the two summed fields and divide them to get a completion percentage. Easy enough, right? I created a field with the control =[sum1]/[sum2] and set the...

Ah, if that's what he's looking for, I'm not sure I understood the question... I thought he wanted "today" only as his "Date." Yeah, Janjang it'll only change on "new" entries with Date(). All previous entries will remain the same.

Oh, one I can actually answer... In the default date field (in table design mode), just put #06/06/2006# (or whatever date you want to be "default"). The default date will remain that date. I hope that answers your question.

On 9/4/06 he would begin accruing days at the rate of 6.67 hours a month (that month included) though Dec. He would continue to accrue at that rate all through '07, giving him 10 days. On 09/04/10 (his 4 year mark), he would begin to accrue at the next tier rate. So he would have the first 8...

Thanks Doc, and I understand what you saying, but I'm not sure if it does need to be too complicated as far as "rules." Though 115 is a significant amount of people, I'm certainly willing to do some things manually, which may ease some burden on figuring the solution. We have one HR person...

Bob, it's funny you say that because I've jokingly made that suggestion at work! I can't say it is too fun for the majority of the workers there... it's a production environment with very little social interaction, but I'm trying to change things (I really have not been there long). The...

Thanks for your reply Bob! I'll try to explain as clearly as I can. 1) Employees are hired on as "Temps," needing to complete 90 days of service before being hired on as permanent. Only then can their vacation accrual begin. It is strictly Jan-Dec without rollover. At Jan, the counter...

Please bear with me. I'm fairly new to access, and have learned much in the past three weeks I've been "learning" how to use it. I was simply sick of the process that was going on at my place of business where I'm a Manager (I've been there for about 3 months). We keep about 10 Excel forms...