Sorting Text

[Bert666]

Hi there,

I am designing an Inventory Database using Access 2000 -

Now there is a field (Text) that will be used to specify the location - it can be numeric and alpha numeric - e.g

1A/01
2/09
Area1/08
4/09

Now i want to sort these records alphabetically - e.g

Area1/08
1A/01
2/09
4/09

but i cannot seem to get around this - Can anyone help??

Bert.

 

[Mike Powell]

Open the table that houses the data. open in the design mode and select the field that you want to sort. On the bottom of the page, select indexed. You have No , Yes with duplicates and yes with no duplicates. Select either of the yes options, depending on your choice. Close and save. That field will now be indexed. If you want to sort your query, select the sort option on the design page, and select ascending.


Mike

 

[Bert666]

Thanks Man

Thanks a million man

Bert.

 

[Mike Powell]

No Problem

Mike