What's the query look like now?
> -----Original Message-----
> From: Jake . [mailto:[EMAIL PROTECTED]
> Sent: Sunday, April 04, 2004 5:09 AM
> To: CF-Talk
> Subject: Re: Grouping help
>
>
> Not sure if that would help. I'll have to check it out, since
> I'm using Access. Thanks!
>
> >If you are using dates to group by, make sure to get rid of any
> >extraneous information from the datefield. If you are using SQL
> >Server, a datetime field will return the date, hours,
> minutes, seconds,
> >and milliseconds. You can use a CAST or CONVERT function in
> your SQL
> >statement to limit what is returned to just year, month and day.
> >
> >
> >
> >SELECT theTitle, CONVERT(varchar(10), theDate, 101) AS dateasstring
> >FROM theTable ORDER BY theDate
> >
> >
> >
> >Would this help any?
> >
> >
> >
> >Jeff Garza
> >
> >
> >
> > _____
> >
> >From: Jake . [mailto:[EMAIL PROTECTED]
> >Sent: Saturday, April 03, 2004 10:00 AM
> >To: CF-Talk
> >Subject: Re: Grouping help
> >
> >
> >
> >Thanks, I appreciate the help. Looks like part of my problem is (as
> >always) the fact that I'm using dates. Does this method work with
> >dates?
> >
> >
> > _____
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
