Sorting fields

[djhender]

In the data base I am trying to set up, the first field is Catelog Numbers. can I get the access to sort these numbers and put them in order? I only find alphabetic sorting. Obviously, I am totally uneducated on this and figuring it out as I go. Thanks for any help

 

[Brian Welch]

Well,
First of all the A/Z sorting will work on numbers too.

Otherwise, if you want them to appear in order, you can have the forms
recordsource be:

Select * from [tablename] Order By [Catelog Numbers]


Hope this helps

Brian Welch

In the data base I am trying to set up, the first field is Catelog

Numbers. can I get the access to sort these numbers and put them in order?
I only find alphabetic sorting. Obviously, I am totally uneducated on this
and figuring it out as I go. Thanks for any help

 

[John Vinson]

In the data base I am trying to set up, the first field is Catelog Numbers. can I get the access to sort these numbers and put them in order? I only find alphabetic sorting. Obviously, I am totally uneducated on this and figuring it out as I go. Thanks for any help

First off, don't try to sort a Table: a table *has no order*. Instead,
use a Query, with an Ascending (or descending) sort on the Catalog
Number, as the recordsource of your Form.

You say it's sorting alphabetically. What's the Datatype of the
catalog number? What are some typical values?

 

[glue]

It sorts depending on the field type. if it is stored as text, it i
sorted alphabetically, even if the field contains only numbers.

if you go into design view of the table, you can change the field typ
property. It will warn you that you are about to lose data if an
record has a catalog id that is not numeric. so be careful abou
that.

anyway, then save your table, open it up, then sort by catalog id, an
it should be in numeric order

gl
aaro

 

[glue]

It sorts depending on the field type. if it is stored as text, it i
sorted alphabetically, even if the field contains only numbers.

if you go into design view of the table, you can change the field typ
property. It will warn you that you are about to lose data if an
record has a catalog id that is not numeric. so be careful abou
that.

anyway, then save your table, open it up, then sort by catalog id, an
it should be in numeric order

gl
aaro