I resemble that search!
LOL
Fred
----- Original Message -----
From: "Olive, Christopher M Mr USACHPPM"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2000 3:14 PM
Subject: RE: Order by a field with multiple keywords
> you're subject line is close to the actual solution. :)
>
> try.
>
> SELECT
> fred,
> fred2,
> fred3,
> region
> FROM
> sometable
> GROUP BY
> region
> ORDER BY
> region
>
> Chris Olive
> DOHRS Website Administrator
>
>
> -----Original Message-----
> From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 09, 2000 1:22 PM
> To: Cf-Talk@Houseoffusion. Com
> Subject: Order by a field with multiple keywords
>
>
> Hi, All
>
> I have a table with a "region" field that would contain
several entries
> (Central Coast, California, West Coast, USA). How can I
display the list by
> each individual region? Most records, of course will be
displayed several
> times in each subgroup.
>
> All I can think of is make a list of all regions and then
run a query for
> each of them. Is there a better way? With just one query?
>
> TIA
>
> Cyrill
>
>
> ----------------------------------------------------------
------------------
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or
> send a message to [EMAIL PROTECTED] with
'unsubscribe' in
> the body.
> ----------------------------------------------------------
--------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=li
sts/cf_talk or send a message to
[EMAIL PROTECTED] with 'unsubscribe' in the
body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
