Joe,

I have two fields in the table, a high value and a low value, while some values are alpha (thus the varchar type). I need to create a Where statement...

So are u saying that the SQL protion of the code I posted should work. I am trying to get the SQL protion correct. The Cold Fusion just send the...

Let me clarify. I developed in Access but need to migrate to SQLServer. Access code works well with Access db(note that I am using Cold Fusion thus the pundsigns and...

Greg,

One more question, I currently use an inner join to pull in the name of the project from another table that has the project ID and the ProjectName. Can I...

by the way, what is 'mud DESC'??

GregLyon,

That was it!!! Thanks for this solution!! Thank you!!!

-Jon

GreyLyon,

I see what you are trying to do, but I believe I messed the syntax in translation. What have I done wrong here? My table name is rfq_files.

ODBC Error Code...

This doesn't really do it... see result below.... I need it to take whats below and sort the groups of projects by date... so that the project at the top is...