Database results

[Guest]

PI have been struggling with a database results page and this is the first of
probably quite a few questions! -- When I access the results page the latest
results are always at the end. I would like to reverse this so that the last
input shows at the top of the results Page. How do I do this please?

 

[Clark]

Go into your DRW and edit the query to put at the end a statement something
like:

ORDER BY YOURTABLENAME.YOURFIELDNAME DESC;

The fieldname might be the ID if you have an autonumber field that is in order.
The DESC causes it to list in descending order. Leaving off the DESC causes it
to list in ascending order.

 

[Guest]

Thanks for your reply Clark.
Firstly, If I alter anything in the Wizard then I will loose the formatting
I have spent so long doing - right? So i would rather not do that if there
is a way around it.

Secondly, having added the line you suggest I get the following error
message when I go online: No value given for one or more required parameters.

Apreaciate your help.

 

[Kathleen Anderson [MVP - FrontPage]]

What does your SQL look like after you added the code from Clark? Can you
paste it here?

 

[Guest]

Hi Katheleen : The data is as follows:

SELECT * FROM Results
ORDER BY employees.ID DESC;

Any ideas?

 

[Kathleen Anderson [MVP - FrontPage]]

It looks like you are selecting data from one table - Results - and trying
to use a field from another table - employees - to sort the data. That's not
going to work without some modification to your SQL.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Clark]

Firstly, If I alter anything in the Wizard then I will loose the formatting
I have spent so long doing - right?

Not necessarily. I think at the end of the DRW process you get asked whether you
want FP to regenerate the results. Now I am not 100% certain on this, but I
think if all you have done is change the order of things as suggested, you can
choose not to have your results regenerated and you will be all set.

Actually, you dont even have to use the Wizard. You can go into html view on the
page, find where your query is (in gray, not in maroon) and modify the SQL with
the ORDER BY statement right there. Save the page, and you are good to go.