Microsoft Access 2010

  Kingfisher 16:57 15 May 2012
Locked

I have an access database of my film collection, column 1 is the number count ie 1,2,3 etc. I have reached 1,000 entries but on entering 1001, 1002, and then clicking a to z to put numbers in the right order, the 1000 plus entries show after the 100 number ie 098,099, 1000 1001. How can I get the 1000 plus entries to show after 999 thankyou

  Woolwell 17:15 15 May 2012

Do you have the column 1 formatted as text or number - try number? Is column 1 auto generated?

  Kingfisher 17:58 15 May 2012

Thanks Woolwell will give it a try and post back

  lotvic 18:39 15 May 2012

I'm confused, are you using Access or Excel?

  Kingfisher 19:00 15 May 2012

Hi lotvic it is an access database

  Woolwell 19:44 15 May 2012

In table design under data type choose number and this should resolve your snag.

  lotvic 20:59 15 May 2012

Was just making sure :) follow Woolwell's advice

  Kingfisher 22:06 15 May 2012

To Woolwell and lotvic, thankyou for your advice it worked problem sorted

  Woolwell 22:08 15 May 2012

Tick as resolved. Under text strings the 1 is before 9 no matter what follows. Glad it is sorted.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?