hi graham
> However, the birthdays for say, May, are not all grouped together
change
order by BirthDate asc
to
order by Format(BirthDate, 'mmmm') , BirthDate
when you use the GROUP= parameter in nested CFOUTPUTs, the nesting needs to
reflect the sequence of columns in the ORDER BY and vice versa
you are fortunate that your specs allow you to group results based on the
month of the birthdate
if you are ever asked to prepare such a list based on "the next two weeks"
or something similar, you may flounder for a while trying to do the date
calculations, so have a look at my solution here --
Birthdays in the next two weeks
http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_ci
d458485_tax285649,00.html
rudy
http://rudy.ca/
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "rudy" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
