I figured out what I was doing wrong. I added back to the end of statement

GROUP BY Location,A.EmpId,EmpLastName,EmpFirstName,A.Type,A.Total_Hours.

that caused all the rows to be displayed.

Thanks for all...

Im still getting the same output with the new code?

Here are the create table statements:

CREATE TABLE #tblTimeOffRequest

(

[EmpId] [int] NULL,

[Type] [varchar](40) NULL,

[From_Date] [smalldatetime] NULL,

[To_Date] [smalldatetime] NULL,

[Total_Hours] [decimal](5, 2) NULL,

[Status] [varchar](20) DEFAULT ('Pending'),

)

INSERT INTO #tblTimeOffRequest

...

I am already doing a case statement to get to where Im at right now for the columns. The original data is in one column so I have split...

I guess I should have been more specific. I can add a Id column without a problem. I only put the first few servers down as sample data....

Have you looked into converting your Access front end to a Access .adp project? I have converted all of our company Access databases over to Access projects withe SQL...

Here is a link that might resolve your problem.  http://support.microsoft.com/kb/Q269824  Hope this helps.

What version of Access are you using?  If its 2000 or greater, why not just create an Access project and then you dont have to worry about linking tables to...

Vladan,

This works great also.  Its nice to see more than one solution to a problem.  I usually would have the Response_Code, priority in a table, and may add it and...

I am still working on it.  It seems to work but I had to include the criteria in the Not Exixts statement as below:

SELECT Response_Code, Site_Id, Count(Alert_Id) as 'Total_Alerts', 1...

Sorry, this is using SQL 2000, we have not upgraded to 2005 and probably won't for a while.

Thanks

DT

Why not just change the database to a Access project that connects directly to SQL?

I realize I should have left the ID, ID-PRICE_1789 off the list, you are correct and I hope it wasnt too confusing.  There are no duplicates for the ID field...

The ID field is not one of the search criteria, I just need the value returned as in the statement above.  I am inserting this ID field in another table...

Works Great!  Thanks for the advice.

David