Search results for query: *

Hi, I have a database that I am trying to generate a work call form in which all data regarding hours worked is saved to a show. The basic idea: Show and Call - Main Form Job - Subform 1 Employee - Subform 2 The design is supposed to allow easier viewing. The main form is unbound...

I'm trying to generate a report that will bring out information like the following: Team 1 Team 2 Team 3 Show 1 Date Time In Date Time In Date Time In Show 2 Date Time In Date Time In Date Time In Team names are a list box that I would need...

I don't have a rates table - no unified way exists for determining rates across departments.

Hi, I currently administer a massive database to calculate payroll. As of June 30, all wage rates are changing for the new fiscal year. What I need to do is preserve all historical data, hopefully in an archive db,(wage rates, dates worked, hours worked, etc.) and allow for the new rates and...

Hi, My question is kind of vague but here's my situation... I have two databases, one to track payroll and one to track vacation/sick time. Some, but not all, vacation/sick time info comes from the payroll database but is manually entered into the vacation/sick time db. Is it possible to get...

Works beautifully! And simple enough to change :) Thank you!

Happy Almost New Year! What I have: tblVacation Hours Granted VacPurchased VacCarryOver VacMarch VacJune Case 24 120 40 40 1 12 60 30 30 2 0 80 20 20 3...

Golom, My apologies for not getting back with you sooner... I've just gotten back in the office. The information you asked for (probably more than but better more than less): Employees (Table) FileNo DeptNo SSN First MidInit Last Hours Granted (Table) HGID FileNo YearGranted VacCarryOver...

I'm currently building a vacation/sick time database with the intention of tracking an employee's time that is granted, used, and when. I've completed this part of it. After showing this to my supervisor, he added the fact that vacation time can be used after two specific dates if the current...

Works beautifully! Thanks!!!

I've built a timesheet/payroll database and I have one part left to complete in it. What I have (a sample): ProjID RegHours OTHours RHours D04Beer 3.5 0 3.5 M04Rats 4 0 4 Pfront 6.5 0 6 Pbox 4 0 4 Pbox 7...

I should have mentioned this before... frustration got the best of me. When the IIf statement is in the criteria row, it removes the records that need a half an hour subtracted completely rather than just subtracting the half an hour. My logic in using the criteria row was that I could use...

Hello, I've built a database to keep track of payroll information and I need to have it automatically deduct a half an hour if the person works more than six hours. The complicating factor is that I only need the deduction if the person is in a certain department and worked a certain project...

Rick, The shortcut worked!!! I put the shortcut in the network file with the database and as long as that shortcut is used to open the database, no problems! Thank you!!! Val

Hi, I've come across so much information on Microsoft Access and how to implement security, I'm all sorts of confused on where to even start with my problem. The general idea: I have built a database that I need to define user-level security for. The database will be located on a network...