Search results

I have a db of employee information and need help with a query. My table has all the employee information, including hire date, terminated date, and rehire date. I have one query of terminated employees, but need help with the active employees query. There are a couple employees who were...

I've built a simple db for tracking employee's PTO (paid time off). I'm experiencing an error with a field I want to add to the form, and can't resolve it. Sad, because I don't think it's a complicated fix, but the solution evades me. Two tables 1 - Employees (name, hire date, Total Annual PTO)...

I'm hoping that someone can give me some insight into this problem. I'm on Windows 7 at work. I'm using MS Office 2010, Outlook 2007, and QuickBooks 2011. I thought it was just related to Office, but QB isn't a MS product. When I'm in, let's say Access, and I click on the Help button, I get a...

I took over this spreadsheet, but I need help fixing an IF statement. This is a quiz summary sheet. You put the answers in from the quizzes and it scores how the person did. Normally each question has one answer. Questions can be multiple choice, T/F or Y/N. On this particular quiz...

I was thinking about posting our company's calendar or schedule of events on our website... but I don't want to have to be the one who keeps updating it, especially if I am out of the office. What would you recommend I use so that someone else (who may not be as familiar with webpages) can...

I have created a new inventory db based on our old one. It looks very similar with a few minor changes. In the old db, there was a formula in the subform that calculated the # purchased minus # used. In the main form, the Units in Stock referenced this formula. I copied the formula exactly...

Is there an easy way to remove a switchboard from the database? We don't use it. An easy example to use would be the Inventory Control database Access has set up already as an example database. It's the same one we used for our Inventory Control. Thanks.

I have a timesheet database that is going to be used by multiple users at the same time. More than one person can enter their data in on a separate record. I was also in it and was trying to make changes to a different form. It told me I may not be able to save the changes I was making. How...

I have set up a basic timesheet for the employees. Everyone wants to enter the data differently, so I need some help on making it simple. 1. Is there a way to let them enter time without the ":" (ex. 900 = 9:00 or 1100 = 11:00) 2. Is there a way to let them enter the time without having to...

My brain doesn't seem to want to find the answer to this. I have a timesheet database. The RPT is grouped by Employee ID and by Date. I have everything set up the way it should be and the way it should look. However, my Total Hours seems to be giving me a running sum after each date group...

I have created a fairly simple expense report in Access. The info gets filled in on a form. Under the query, all I do is specify the criteria as the person's name, beginning date and ending date. My report is grouped by name (in case we want to run more than one person at a time). Under the...

I have two tables: TABLE A( name, week begin, week end, company) and TABLE B(name, date, expense, description, amount). I have tried to create a form/subform, but am having trouble. Form (table A), Subform (table B). I'm trying to create a one-to-many expense report where the person types in...

I have a report based on a PC Inventory table. The table contains 3 locations (ex. Chicago, Houston, Atlanta). Within each location, the employees are listed with their desktop info, Monitor info, laptop info. My report is grouped by location. What I am trying to do is count how many...

I have a query based report that needs to show the sales rep name who prospected the account, but I need to limit the characters that show up. The field looks like this "Doe, John(Atlanta 1061)". I have tried to do a simple =left([SalesRep],10), but I keep getting errors. Can someone explain...