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

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
_____________________________________________


"Graham" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
|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
|
|

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

"Stefan B Rusynko" <(E-Mail Removed)> wrote in message
news:uz$9$(E-Mail Removed)...
> 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
> _____________________________________________
>
>
> "Graham" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> |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
> |
> |
>
>

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

--

_____________________________________________
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
_____________________________________________


"Graham" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| 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
|
| "Stefan B Rusynko" <(E-Mail Removed)> wrote in message
| news:uz$9$(E-Mail Removed)...
| > 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
| > _____________________________________________
| >
| >
| > "Graham" <(E-Mail Removed)> wrote in message
| news:%(E-Mail Removed)...
| > |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
| > |
| > |
| >
| >
|
|