98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » ACCESS
ACCESS
Resolved · Medium Priority · Version 2003
Fri 21 May 2010, 15:47Delegate Anis said...
Anis has attended:
Access Introduction course
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
ACCESS
I've created a database consisting of 134 records.
I'm trying to produce a report of these records with records running consequentially i.e. 1,2,3....... However, this does not appear to be the case. When I click on the scroll button to go from 1 to 2, it doesn't, it goes strailgt from 1 to 10 then 100, missing out the middle numbers in between.
I've look at one of my tables and see that the records don't run consequentially but are at random. Id the problem linked?
Anyway I'd be grateful if you could enlighten me as to what the problem could be here and how I could overcome this?
Many thanks.
Regards
Anis
Fri 21 May 2010, 16:16Trainer Stephen said...
RE: ACCESS
Hi Anis
Thanks for your question
The sorting behavior you describe suggests that your record numbers are saved as text rather than numeric values. For starters I suggest you look at the data type of the record numbers. If they are text, try converting them to a numeric type. This should then solve the problem.
If this doesn't work, please let me know and we can consider other options
Regards
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Insert The Current DateTo insert the current date into a Table field or Form Text box use: |
