When i use that it just displayes the code in the cell. My first few colums look like this

000012323 a1

00001240 ...

Sorry i wasnt clear. I was provided a list in excel with previous id's. i.e.

1234 In the database this is displayed as 0001234

0000417 correct

0014789 correct

12...

hrmm, when i do that it turns the number to zero, myabe this would be easier in access?

Im sorry im not too knowledgeable with execl, i tired highlighting the column, and adding your code in the fx box, but it didnt work. Im sure im missing something...

Thats similar to what i did, but now since some numbers were only...

I have an add on program in execl that will let me padd with zeros, so i did a blanket padd of 5 zeros, but how cut i cut off...

This data is in the database correctly, its the excel file that i need to padd with zeros, so i can then use those values in my query. So the...

Can you explain in MORE detail why i needed the max/min? It WORKED, using this

select distinct p.first_name

,p.last_name

,p.people_code_id

,max(case when td.event_id = 'sd 101' then final_grade else null end) as 'sd...

same issue as above ^^

Why do you use min or max? My case without either seems to work.

This seems to work just as well, any reason I NEED the max statement?

case when td.event_id = 'sd 099' then final_grade else null end as 'sd 099'

,case when td.event_id...

^^ That might work, let me try it with some testing.....

Why use max?

To get a distinct list of classes i used

select distinct event_id

from event

to get the people i needed (alums in spring 07) I used.

select distinct p.first_name

,p.last_name

,p.people_code_id

,td.event_id

,td.final_grade

from people as p...

Currently im just pulling data FROM existing tables, Do i need to create a new table to get this format?

Im not looking to load this data INTO a table,...

Thanks for the help guys, ill let you know how it goes.

I know how to script the jobs, but how do i script the logins? Once i ahev the script for them, do i just run them in QA on the...