ACCESS

Resolved · Medium Priority · Version 2003

Fri 21 May 2010, 15:47 Delegate 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:16 Trainer 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

Fri 21 May 2010, 16:32 Delegate Anis said...

RE: ACCESS

Thanks Stephen.

Yes, i changed the field from text to number. However, that partially resolved the problen. What I then did was assign a primary key to that field. That seems to have done the trick.

Anis

Training courses