Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Microsoft Access 2010

Kingfisher

Likes # 0

Posted May 15, 2012 at 4:57PM

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

Like this post
Woolwell

Likes # 0

Posted May 15, 2012 at 5:15PM

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

Like this post
Kingfisher

Likes # 0

Posted May 15, 2012 at 5:58PM

Thanks Woolwell will give it a try and post back

Like this post
lotvic

Likes # 0

Posted May 15, 2012 at 6:39PM

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

Like this post
Kingfisher

Likes # 0

Posted May 15, 2012 at 7:00PM

Hi lotvic it is an access database

Like this post
Woolwell

Likes # 0

Posted May 15, 2012 at 7:44PM

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

Like this post
lotvic

Likes # 0

Posted May 15, 2012 at 8:59PM

Was just making sure :) follow Woolwell's advice

Like this post
Kingfisher

Likes # 0

Posted May 15, 2012 at 10:06PM

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

Like this post
Woolwell

Likes # 0

Posted May 15, 2012 at 10:08PM

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

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.