Number order

T

TAGFC

I have a field that i am using to group data with (ie tyres, rims, etc). In order to get a report in the right order for my needs I have called the data (1) Tyres, (2) Rims etc. Unfortunately the order in report goes (1), (11), (12), (2), (3) etc. Is there anything I can do about this?
 
A

Allen Browne

If you have set up a field in a table that contains the number for the row,
open the table in Design View, and change the Data type of the column from
Text to Number. It will then be sorted in numeric order.

If you are using a calculated field, use CLng() or similar to coerce Access
into treating it as a number. For more information, see:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

TAGFC said:
I have a field that i am using to group data with (ie tyres, rims, etc).
Click to expand...
In order to get a report in the right order for my needs I have called the
data (1) Tyres, (2) Rims etc. Unfortunately the order in report goes (1),
(11), (12), (2), (3) etc. Is there anything I can do about this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Page numbering with Merged Document and IF statements 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Possible to Combine reports to's to a single box? 0
Linking Child Timelines to Multiple Parents 0
Filling certain fields with pre-determined "ranges" 1

Top