Trying to keep track of time off request......need to get the difference in the time the employee leaves and the time they get back using a query

Hi, I have a database that holds thousands of employees and their info. That information is updated at least once a month (change in telephone...

I have a db with several dozen queries. I need a non-technical person, who is also not authorized to see all the info in the db, to run one query each...

I am subtracting a date and time (General Format) from Now() and wish to see this in the form of Days:Hours:Minutes for purposes of Payroll, for my business....

I'm trying to run a query using a date from a form as criteria, but the query responds as if there is no filter criteria. Is there some particular format I...

When using parameters: If the user wants all records to be returned, without the filtering that the parameter was set up for, is there a word, such as "All"...

In Visual Basic I get a duplicate output destination error for the following query SELECT * FROM tblB INNER JOIN (tblD INNER JOIN (tblC INNER JOIN tblA ON...

I have a query with fields Q1, Q2, Q3, Q4. I want to collapse the answers for questions 1-4 into either 1 or 0. So, I am using Iif.... Q1KR:...

I am developing a query that needs to show several fields of straight data, along with one field that needs to look up someone's name, if they fit certain...

Microsoft Access "Classroom management database" question. When grading, it has the ability in this template to put in scores for Assigments, Quizzes, Exams,...

Hi all, I have googled and there is Update top N in SQL 2005. However, looks like it is not in Access 2007. Can someone please suggest me what to do to...

I have a query that when run opens into a form, however when there is no matching record in the database the form opens as a grayed out box. This is fine for...

I am not sure if I can do this but I have this data in my table Date1 Shift1 Temperature Date1 Shift2 Temperature Date2 Shift1 Temperature Date2 Shift2...

Hello, Let's say I have tblSubject, containing Subject ID's (SID), w/ a one to many relationship to tblData, which contains the Subject ID (tblSubject.SID),...

I have a bit of a challenge in front of me with a requested monthly report that will translate a list of departments that have not approved their monthly...

Hi All, I have an issue with a query running long (Fig 1). Is Fig 2 doing the same thing? It runs much faster, but just wanted to make sure it is doing the...

Could someone please advise if the following is possible. I have a table of dates not all dates are represented. I would like to group these dates into...

I have a table where one field needs to be parsed into 7 columns. Each field is separated by a "/" - examples shown below. I'm most familiar with queries and...

Hello, I have a query of slot players that is sorted by their level of play - 3-months, 6-months and 12-months - in ascending order. I would like to give...