Specify the sorting order of database results

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

Guest

In Front page 2000 I use the Database result wizard. In step 3 of 5 there is
a "more option" field then has an order button. I am trying to have that
order set numerically by numbers. Apparently this was set up to order names.
this is my current result

8988
8916
6956
60
4877
4494...

As you can see the order is not exactly correct. Is there a way for me to
modify this.

Thanks,
 
Hi,
You'll need to set the field in your database to be numeric rather than text
 
You must log in or register to reply here.

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

Access Default Microsoft Access Order Entry database issue 0
Sorting the results of a query 1
FP Database Result missing Criteria/Ordering 2
Preferred way to do sort order - column in table, or specified in query? 3
change order of fields in emailed form results + email hyperlink 2
Column Sorting for DB Results 3
email sort order 4
FP DB Result grayed out criteria/Ordering 1

Back
Top