469,276 Members | 1,714 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,276 developers. It's quick & easy.

MS ACCESS FORMS using ORDERBY with [fieldname] in descending order

In MS ACCESS version 2003 I have a form that is based on a table. I have indicated that I want the form to display the table content in the order of the tracking id number (InvoiceNumber)which is an autonumber field.

In detail view of my form, I select the upper left corner black box properties to get to:

Form - Properties
Record Source - Table1
Order By - Table1.InvoiceNumber

As the field is an autonum the form opens, nothing is displayed. I roll the wheel on the mouse and the default goes in ASCENDING order beginning at record #1. I want to reverse that so that the form will display the last record first at record #7046. How can I do this? - thanks A.
Sep 2 '10 #1
2 12827
if you open your form then apply filter descending, save your form. Next time it opens it will list items in descending order however, the autonumber new record will still appear at the bottom of the screen so you would (if you had many records) have to scroll down. What's so important about having the last record appear at the top of the list? Why not just goto last record entered when form is opened, easier plus you see the last records entered right away!
Have an idea of getting around this but don't seea point to doing so!
Jan 2 '11 #2
2,321 Expert Mod 2GB
Hi and welcome to BYTES.

You can change your orderby to:
Expand|Select|Wrap|Line Numbers
  1. Order By - Table1.InvoiceNumber DESC
where DESC stands for descending.

Please note that we have a specific access forum on Bytes: Access and VBA
Feb 28 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Talis | last post: by
3 posts views Thread by Leszek | last post: by
4 posts views Thread by Newbie | last post: by
2 posts views Thread by Richard Hollenbeck | last post: by
5 posts views Thread by subramanian100in | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.