Search results for query: *

This may be a hard one. I have a sheet that has employee ID's,metrics and months. I want to count how many times an employee repeated the same thing but not month after month. For example, If employee 25 had "C3" for Jan and then again in Feb I don't want it to count. But if the employee had...

Here is an easy question for you pros. I was unable to find this anywhere. I need to convert a date that looks like this: oct 16 2005 10:35PM into this 22:35.. What is the function to convert to shortdate?

I need to figure out the duration of time someone logged off the phone for different reasons. Each record has a logoff and a Logon. In order to determine the duration I have to look at the very next record to see what the logon was. If someone logs off for a reason (reasons are numeric 1-5)the...

I have field that has the days worked like this MTWR--- or -TWRFY-. I need to count the days worked and need to exclude the dashes. How should I do this?

I have a field called row_date which looks like: 05/01/2005.. It's in the date format. If I use MONTH(row_date) as Mnth, it comes out as a 5. I would like to format the date as May. Does anyone know a different function I could use? Thanks!

I have a query where I want to return records with the month instead of the date. The records are listed by day. Here is the Query: Select MONTH(row_date) as Mnth,sum(acwtime)/sum(acdcalls) as acw from dagent group by ??? I need to group by the month so I do not get every record but I keep...

I have 15 tables that are exact replicas of each other. ON a form I have 15 queries that represent the 15 tables. I have little time so I can not recreate the database right now. The user needs to be able to move a record from one table to another on the form. The user may choose any record from...

I have two different columns with names from different databases. I need to see if the names in the second column are in the first column. The names are the same but in one column they are first, last and in the second column they are last first. Some names have intials and in the other column...

In column A I have employee id's, in column B I have Yes or no. There are hundreds of records. I want to know how many "no's" each employee has. For example. Employee 114 has 100 "No's". I just want the total to appear in a table beside each employee ID. What formula do I use?

I'm working with a date/time field in which I need the military time ( short time) to display, however once the time is in the " short time" data type I need for it to be changed to a number data type without loosing the format. For example if the " start_time" is 13:00 I need to change the...

I have built several Access 2K database's at work and suddenly when I use a combo box to look up a value on my form I'm getting an error message that reads " error accessing file network connection may have been lost". I created a new form and got the same message. I have tried all of...

Hi! I'm a Business Analyst and consider myself a pro at Access. I have built many Access databases at work. I even use Access to query data through ODBC from a SQL server. My company now wants me to learn SQL Server 2000. I familiar with the SQL language and I use it often enough that I think I...

I have a list of names for example(Sally,Joe,Mary) and beside those names I have something called a Q score for each person and beside that a H score for each person. I want a user of spreadsheet to pull a name from a combo box box and have the cells (A1:C1) update with this information. I plan...