Sorting fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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




djhender said:
In the data base I am trying to set up, the first field is Catelog
Click to expand...
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
 
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
Click to expand...

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?
 
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
 
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
 
Back
Top