When you use the wizard it gives you the option to group (order)
Normally to sort you just add and ORDER to the end of the select
(ASC or ascending, DECS for descending) as in
Select * from tablename WHERE fieldname1=::variablename:: ORDER BY fieldname2 ASC
Or post your SQL select statement
--
| That occurred to me also, but as I know next to nothing about the syntax of
| SQL, I need a pointer or two to get pointed in the right direction. How do
| you express multiple statements?
|
|
| Thanks
|
| Graham
|
| | > Why not modify the existing query to also sort fields
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| | > |I already have a Custom Query to change the date filed in my DB. Now I
| want
| > | to sort the field.s How do I add another query without completing the
| wizard
| > | which adds another copy of the results to the page?
| > |
| > | regards
| > |
| > | Graham
| > | 7/7
| > |
| > |
| >
| >
|
|
