I am trying to expand past my current limited abilities with this and Man! am I getting a heading..!

Here is what I am using..

I can get it to work without the smeLastName. But, not with..

What am I missing?

PHP Code:

strQ = "SELECT SUM(trTime) AS TtlTime"
strQ = strQ & " FROM smeTracking a "
strQ = strQ & " INNER JOIN sme b  "
strQ = strQ & " ON a.smeID = b.smeID "
strQ = strQ & " WHERE a.ppID = "
strQ = strQ &  strppID
strQ = strQ &  " GROUP BY a.smeID "
objRS.Open strQ
 
 
<% While Not ObjRS.EOF %>
 
Response.Write  objRS("smeLastName") %> - <% Response.Write  objRS("TtlTime") %> <br /> 
 
 
<%
objRS.MoveNext
Wend
objRS.Close
objConn.Close
%> 


Thanks for any direction

~Chip

I'm not sure how you're approaching this? When you try to get the last name, are you adding that to your select and group by clause?

It's not working because smeLastName isn't a SELECTed field in your query. It would look something like:

strQ = "SELECT smeLastName, SUM(trTime) AS TtlTime" ...

Thanks Forrest and Adam.

I see, (I think.) I'll give this a try and get back with results +

ok. I see what problem I'm not able to overcome. I see what you are saying Adam. I need to request the info if I want to show it.

The smeLastName is not in the smeTracking Table. It is in the sme table.

TABLE ONE: [sme] I have a table that lists sme's (Subject Matter Experts.)
This table has sme name and ID number for each sme (smeID which is generated as a primary key.)

TABLE TWO: Then I have a talbe that records the time on any given project they work on. This table uses the smeID number from the sme table then a field for hours worked, and another field for the date, and finally a field with a project number in it.


What I want to do is output a list that shows how much total time each sme has for the project...

I am learning a lot from this project, so I really do appreciate the help!

kewl. i actually hav no idea wat u guys r talking about. other than some kind of programming... tried that myself once and failed miserably

but anyways... COOL