Microsoft Access 2010

  Kingfisher 15 May 12
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 15 May 12

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

  Kingfisher 15 May 12

Thanks Woolwell will give it a try and post back

  lotvic 15 May 12

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

  Kingfisher 15 May 12

Hi lotvic it is an access database

  Woolwell 15 May 12

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

  lotvic 15 May 12

Was just making sure :) follow Woolwell's advice

  Kingfisher 15 May 12

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

  Woolwell 15 May 12

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

Advertisement

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

Windows 10 Home vs Windows 10 Pro comparison: Here are the extra features you get in the Pro version

Why Formula-e needs to go faster

How Instagram spots trends

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message