select statement

[tjm77]

I am running into an order by problem. I have the following select statement:

fp_sQry = "SELECT * FROM tblCMPS WHERE techID = '" & techid & "' AND year(rptMonth)=" & tYear

It works fine, except that there are two tabs on the webpage, one for 1999 and 2000, the 1999 orders by month just fine, but the 2000 data does not. any ideas on how to fix this??

 

[iqof188]

Try to include ORDER BY Month in your query statement. Apart from that, it is always recommended NOT to use an asterisk in your SELECT statement, since this is bad for performance. If you really want to extract all the columns from your table, write them all out (SELECT month, year, TechId ... etc FROM tblCMPS.) Good luck. <webguru>iqof188</webguru>