Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DateTime question
Thanks for the quick reply :) Yes the data is in chronological order and the query worked perfect. Thankyou Ian -
DateTime question
Hi all, Is it possible to get the datetime value of the first and last records in a table then work out the difference between ? Thanks, Ian -
-
Percentage
@r937 +------------------+--------------------------------------------------------------+ | Variable_name | Value | +------------------+--------------------------------------------------------------+ | bdb_version | Sleepycat... -
Percentage
UPDATE r937's query works fine in access just not in mysql ? -
Percentage
Thanks for the reply’s both :) Seem to be having trouble with both the queries though. towerbase: You have an error in your SQL syntax near 'COUNT(*) AS tt ( SELECT COUNT(*) FROM audit3 ) AS tot FROM audit3 GROUP BY Event' at line 1 r937: ERROR 1064: You have an error in your SQL syntax near... -
Percentage
Hi all, I am new to php & mysql and could really do with some advice as I have been struggling with this problem all day. I am trying to workout a percentage via a result from a mysql column. The column contains server 2003 EventID error codes which have been generated by the OS. i.e: 576...
