Access again

[aceizace]

I was wondering if anyone could explain how to use the 'Order By' box in MS Access. I have an autonumber and i want the whole table to be sorted by the field 'Member Number' when i open it but it doesn't seem to work no matter what i write in the 'Order By' box on the properties sheet. Thanks.

[rinkytink]

I presume that you are in design view of your table and you are going to: view....properties and entering your criteria in the order by properties box there. You need to enter the criteria in this format [table name].[field name].

So your table is called tblClubMembers and you have three fields called 'club number' (your auto number field), 'Member Name' and 'Member Number'.
You want to order by Member Number. Go to the order by box and put in [tblClubMembers].[Member Number].
Remember also that most of Access is case sensitive.