:laugh:Hi, You can use [ Server.Mappath("\\x\\xx.mdb") ] Try this. Thanks "Good Thing Goes With Good People..."

select School, Semester, Grade, Campus, sum(CASE WHEN Status = 'Accepted' THEN 1 ELSE 0 END) AS NumOfAccepted, sum(CASE WHEN Status = 'Rejected' THEN 1 ELSE 0 END) AS NumOfRejected from StudentResult group by School, Semester, Grade, Campus Of course, this is what you have asked for, but not necessarily the best way of going about it... you could always just use count (*) and use the Status as a Column heading also... ------------------------------------------- Don't walk in front of me, I may not follow; Don't walk behind me, I may not lead; Just bugger off and leave me alone!!

Try: SELECT Students.StudentID, CampusList_1.Name As Campus1, CampusList_2.Name As Campus2, CampusList_3.Name As Campus3, Students.Session1, Students.Session2, Students.Session3, Students.StudentName as FirstName, Students.StudentLastName as LastName, Students.DateOfBirth, Students.Street, Students.AppartmentNo, Students.City, Students.State, Students.ZipCode, Students.Phone, Students.ParentFirstName, Students.ParentLastName, Students.SSN, Students.SchoolYear, Students.Semester, iif(Students.Sibling, 'Yes', 'No') as Sibling, iif(Students.Accepted, 'Yes', 'No') as Accepted, iif(Students.Waitlisted, 'Yes', 'No') As Waitlisted, Students.ApplicationDate, Students.CurrentSchool, Students.AltenatePhone FROM Students LEFT JOIN CampusList AS CampusList_1 ON Students.Campus1 = CampusList_1.CampusID LEFT JOIN CampusList AS CampusList_2 ON Students.Campus2 = CampusList_2.CampusID LEFT JOIN CampusList AS CampusList_3 ON Students.Campus3 = CampusList_3.CampusID LEFT JOIN SessionTable AS Session_1 ON Session_1.SessionId = Students.Session1 LEFT JOIN SessionTable AS Session_2 ON Session_2.SessionId = Students.Session2 LEFT JOIN SessionTable AS Session_3 ON Session_3.SessionId = Students.Session3 ORDER BY Students.StudentID

The other thing is, don't use 'Urgent' in the subject line. God Bless, Jason I am not perfect but I try to be better than those before me. So those who come after me will be better than I am.

Hashtable.Add(key, value) Paul

:laugh: :laugh: :laugh: Very good! Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website

You might want to rephrase what you are trying to accomplish. "Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Why do I get the feeling the OP is going to copy'n'paste the code thrown at him and wonder why it doesn't work? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

First, this is the wrong forum for this question. Second, you didn't specify what language you were using. Third, noone is going to write this code for you. You have to write the code yourself to show that you, at least, attempted to do something. When you have specific questions, then we can help. But, from the sounds of your question, you don't even know what the SQL statement would be to delete a record, let alone write the code to execute it. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

More info Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]

:confused: Your question ought to be rephrased. "Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus

Have you figured this out yet? You may want to try using stored procedures to return MORNING,EVENING to the datagrid... "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Hi, Are you sure the indexes of the items in your combobox matches the row indexes in your datatable? Maybe posting a little bit more code might help to tackle your problem. Mark Hybrid DSP: Digital processing and storage solutions. Hybrid GeoTools: Advanced GIS editing tools.

Hi, What is the Type of SchoolID? I am assuming it is "int" then you can try to write this line; List.Add((int)SchoolDT.Rows[cboSchool.SelectedIndex]["SchoolID"],cboSchool.Text.ToString()); Mert Kantarcıoğlu

Have you looked at the Cryptography namespace and try the hash classes there? "Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus

Hi, measure the width of the header (g.MeasureString), and draw a line (g.DrawLine) of that length at an appropriate point. :) Luc Pattyn [Forum Guidelines] [My Articles] this weeks tips: - make Visual display line numbers: Tools/Options/TextEditor/... - show exceptions with ToString() to see all information - before you ask a question here, search CodeProject, then Google

If you don't mind spending the money you can use www.copyminder.com but if I were you I would request the names of the 10 computers and their IP Addresses that the application will be running on this way you can check if a computer is one of these 10 and if so allow the application to run otherwise not. I know it's messy and probably not the best idea, but it will work. Freedom is the right to say that 2+2=5 if this is so everything else will follow.