Sorting in Reports

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

I am using the Event Management Access database template to hold information
about training courses.

I have given the following names to my courses: Training1, Training2,
Training3 etc.

I have built a report to list attendees on the course. Although I have
sorted (ascending) by event name, Training11 comes after Training1!!! How
can I change it so it comes after Training10??

Thanks in advance.
 
Rename the course to: Training001, Training002, ...

Alternatively, split the number into a separate field so the data is atomic.
 
Back
Top