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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Order by particale date
Thank you for quick responce. The count seems very high. Cheers -
Order by particale date
Not sure if i'm replacing everything correctly with the correct names. ------------------ From (Select DISTINCT cDate(Int(A.DateAdded)) As TheDate From TheTable) As A, TheTable As B ------------------ but A.DateAddedd, was this supposed to be TheTable.DateAdded, because thats the only... -
Count Unique items between two dates
I have the follwoing quere SELECT COUNT(*) AS Workstation_Count FROM [SELECT DISTINCT Workstation_ID FROM Machine_Connect]. AS [%$##@_Alias]; I want to count the number of unique items in the DB between two dates. There is also a date field in the db. I'm using SQL - MS Access. Thank you in... -
Order by particale date
OK Thanks for all the great answers. I need to count the numbers of machines between two times on a range of days. ie. Between 21:00 and 06:00 (next day) X computers were added and I need this for a range of dates ie between 21/07/2006 - 30/08/2006. Is this possible? Don't know if this helps... -
Order by particale date
Thats great, however the date field is date and time, and I only want to organise by day and months not time. Thank you in advance. -
-
Order by particale date
Can someone please help me with this. I'm very new to SQL I've got a DB with a couple of field workstationID Date added, notes. I need to collate the information into days. ie we added X workstation on this day. So for each day I can get the total workstations added Is this possible, please...
