maybe something like
select count(*) as ctcount,
(Day(dateadded) & '/' &
Month(dateadded) & '/' &
Year(dateadded)) as dtadded
from activity
group by (Day(dateadded) & '/' &
Month(dateadded) & '/' &
Year(dateadded))
Nick
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 11:38 PM
To: CF-Talk
Subject: OT: Access SQL Date question
Hi everyone:
I have an Access database.
I have a date field (dateadded) w date & time in a table (activity).
i want an SQL to create a table to count entries by dateadded (just the date
part).
something like:
select count(*) as ctcount, ???(dateadded)
from activity
group by dateadded
order by dateadded
I could do this using a combination of access and cold fusion,
but would rather just have an SQL do the work.
any thoughts?
thanks
Sandy
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
