please more info about how to make new intry come out at the top

[Thierry]

You can do a SORT (descending) on the autonumber field.
HTH,
Thierry

"yazoro" <yaz...@bookscafe.com> wrote in message
news:8fa67k$g4u$1...@misc.macromedia.com...
> in a guestbook i want my new intry to come out at the top of the page or
the
> table
> is there a contract that can do this for me or do i have to do it from
> access or the quiry manager
> and howwww???
>
> yazeeed
>
>

[yazoro]

[Edward]

Kind of guessing here but...

You arrange for entries in your database to be assigned an AutoNumberID,
naturally the newest entry will have the highest number. If you create a
query in your database to display all the entries in descending order, you
should be able to create a DrumBeat query based on that query (called a view
in DB). Place a looper on your guestbook page and set the contents of the
looper recordset to hold the result of this query - the results should
display in descending order.

This sort of sounds right

yazoro <yaz...@bookscafe.com> wrote in message
news:8fa67k$g4u$1...@misc.macromedia.com...

[Joe Molloy]

Use an ORDER BY phrase in your SELECT Query

An example of this would be

SELECT * FROM GUESTBOOK ORDER BY Date DESC

Where Date is the field holding the date that the entry was submitted.

Joe

--

Email is packaged by intellectual weight, not volume. Some settling of
contents may have occurred during transmission

hyper...@eircom.net

Phone: 353-86-8764540