problem with 'order by' (1 Viewer)

[yabai]

Hi,

I work at a university and have come up with (+ some help) a db to monitor attendance. The db contains students, courses and an attendance table. So far, so good.

the only probles i have are that i really need to order the results by surname or it is going to be hard to use.

I'm using:
SELECT Students_tbl.StudentID, Students_tbl.Lastname, Students_tbl.Firstname FROM Students_tbl ORDER BY Students_tbl.Lastname;

If anyone has a moment to take a look I would be very grateful.

Cheers
mark

 

[Uncle Gizmo]

Base your form "students" on a query instead of directly on the table, and in the query grid in the sort order field put "ascending" as the sort order For the "last name"!

Cheers Tony.

I have paypal if you want any more help doing your homework!