Thanks Tom,
That has worked an absolute treat.
thank you very much
Leon.
-Original Message-
From: Haapanen, Tom [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 10:54
To: 'Leon Noble'
Cc: [EMAIL PROTECTED]
Subject: RE: Very untidy
select hour(ts), count(ts) from dundeefw
select hour(ts), count(ts) from dundeefw
where date=$date and action=1
group by hour(ts)
Assuming "ts" is your timestamp column ...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Leon Noble [mailto:[EMAIL PROTECTED]]
Sent: 23 October 2001 05:45
To: [EMAIL PROTECTED]
Subject:
