Thanks Rudy and Bob for the solution. Works great! And Rudy, I'll keep your "birthday in the next 14 days" posting in mind--I think I'll need to actually use it for this application. I noticed that the SQL syntax was from MySQL--would it be different for Access2000?
Blessings, Graham ----- Original Message ----- From: "rudy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 10, 2002 8:17 PM Subject: Re: [CFTALKTor] grouping birthdates by month > 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) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Graham Faulkner" <[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)
