Search results for query: *

ck1999, Thanks for the help. I used what you wrote and then added some syntax and it worked great. For those that may need this here is what I used: SELECT qryTI.MEMNO, qryTI.ERNO, qryTI.SRVCODE, qryTI.EDATE FROM qryTI LEFT JOIN qryDups ON qryTI.MEMNO = qryDups.MEMNO WHERE (((qryTI.MEMNO)...

Hi, Thanks for answering PHV. I know not very efficient but it's for a one time thing. A client sent us a file with 26000 records of event history. We need to look at the transfer in and transfer out and if they are the same day then add 1 day. The problem is there are employees with...

I can't use the unmatched query as the values in the qryDups are in the master file. I want all of the records that don't match so I can manipulate a date. I was trying: Select * From qryTI Where qryTI.MEMNO <> qryDups.MEMNO But it keeps asking me for a value. I guess I need a Select MEMNO...

I have a master table that has 1800 records. I have queried the table for duplicate records (qryDups). I want to be able to select records from the master table that do not match the empno in the qryDups. I know that I have to do a where <> but I can't get it to work. Can someone help...

Skip, I can't tell you how great of a help you have been. Consider this a great big cyber hug. Using the formulas that you provided I did figure out how to use it to accomplish what I needed. It may not be pretty and it has one or two bugs to fix but it does what they need. Thanks for being...

Hi Skip, I actually got it to work for 2 fields! Can't do any more than that but still looking at it. By changing =INDEX(OFFSET(Sheet1!$A$1,MATCH($A2,Retiree_Id,0),1,COUNTIF(Retiree_Id,$A2),1),COLUMN()-1,1) to...

Hi Skip, Unfortunately that is the data layout we were sent. It is going into another database to another company and that is what was requested. Our database is a master file linked to the child file that is a one to many relationship. We downloaded the data from our DB2 database and I have...

Hi fneily, Actually I meant to change the wording. I have it in both excel and access. Here are the fields I am working with: Retiree Id Related ID Relative Name Beneficiary Type Relative Relationship Relative Birth Date Relative Gender Beneficiary Percentage Plan Payment Status There are up...

Skip, Thanks so much for your help. I am now able to get the Bene Id for each of the beneficiaries but I need the name also. Actually there are 9 colums of data which are: Retiree Id Bene ID Bene Name Beneficiary Type Relative Relationship Relative Birth Date Relative Gender Beneficiary...

Hi Skip, Thanks for answering. I tried your example but I am sorry to say that I did not follow it very well. Could you take the time to explain the steps to me. I would upload an example but I don't have a way to do that, we are very limitied. This is what I tried: Retiree Id Bene Id...

I need help with a spreadsheet. The table has retirees listed and their beneficiaries. So this is how it is set up: Retiree ID Bene Name 123 wife 123 child1 123 child2 456 wife 456 mother 456...

I need help with a spreadsheet. The sheet has retirees listed and their beneficiaries. So this is how it is set up: Retiree ID Bene Name 123 wife 123 child1 123 child2 456 wife 456 mother 456...

Hello Thomas, Thank you so much for answering. I am trying to run Sharepoint Team Services. I have IIS 5.0 on Server 2000. I currently have 2002 FrontPage Extensions installed. When I go into the properties of my web it says I have Sharepoint running but I know that it's not. Yesterday...

I bumped this up because I am desparate at this point. I have followed this thread:( http://www.tek-tips.com/viewthread.cfm?qid=1111826&page=1 ) but I guess i have a different version of IIS because on my I don't have anything that says Application Pool. My web site is running on port 80 but...

I have IIS on Server 2000. I have 2002 Frontpage Server Extensions installed and during the install it also loads SharePoint. I am also using Frontpage 2003. When I go into IIS and look at the server extensions properties of the web site it also says that SharePoint is installed. I can also...

I've tried this and it works to a point. It create a subtotal but when it does the average it divides by the original number of employees instead of only the number of active employees. In one group there are 16 employees but only 4 active employees. I need to come up with the average for...

Reebo, Thanks for your help. I'll give a try. Trice

I am creating a report for Human Resources that is grouping by salary grade. Grade 1 Location Dept Active Name Salary AMC 6601 T J Doe 200.00 AMC 6602 J Smith 400.00 Average Annual Salary:xxxxx.xx We are reporting on everyone who has been employeed...