Can I get new record to appear at the top of a query output?

[bcmarshall]

I have a select query in descending order, with the most recent on top. The problem I have is that the new record always appears at the bottom of the list.



Is it possible to sort in such a way that I get this type of sort as the output of the query?

New Record
Most Recent
Second Most Recent
Third Most Recent
etc...

I don't know if it's possible to do that way, but for my purposes it would be ideal.

Suggestions would be appreciated.

[pbaldy]

Not really; the new record will always be at the bottom. I've seen the look you're after achieved with two subforms: one in data entry mode right above another showing the rest of the records with allow additions set to no. I've also seen it done with unbound text boxes above the form/subform, with code to add the record.

[JoeM]

Many I am missing something or not understanding the question, but what if you add an Autonumber field to your underlying table (before data entry), and then have your query sort by the Autonumber field in Descending order. Then you most recent record should be at the top, 2nd most recent listed 2nd, etc...

[pbaldy]

I believe the issue is with the new record (the one with empty fields that isn't yet a record), not the most recent record.

[bcmarshall]

You're correct, pbaldy. If I have a dozen records sorted descending, the new record always appears at the bottom of the list, and that's the issue I was trying to solve.

The solutions you offered seem to be the only way to achieve what I'm trying to accomplish, unless someone else has another idea!

[JoeM]

Ah, yes. I figured I wasn missing something.
If I ever had to do something like that, I would go with Paul's suggestion. I can't think of any other better way of doing it.

[pbaldy]

There may be another way, but those are the only two I've seen. You'd think there would be a form setting to control that, but there isn't (AFAIK).