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
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
