By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Counting in update query

P: n/a
I want to make an update query of the following select query(with
count), but don't know how to do it (it's been a while):

SELECT T1.Date, T1.Time, (SELECT COUNT(*) FROM mytable T2 WHERE
T1.Date=T2.Date AND T2.Time<=T1.Time) AS Daycount
FROM mytable AS T1
ORDER BY T1.Date, T1.Time;

This query numbers registered times / day, which i need as columnnumber
in a crosstable.
All fields are present in mytable.

Aug 25 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.