How to implement a "double sort"

[aMember]

I have a database that keeps track of comments users make on files being reviewed. When we review several files at once, things get quite confusing. Among others, there are2 fields, a "filename field" (the type of the field is chars but it is the one that is constrained to ~50 characters) and a integer line number field.

I want to be able to sort on the filename field and THEN line number.

The general 'sort' only lets you sort on one field. Anyone ever sort on more than one?

 

[Golom]

When viewing the table, select "Records / Filter / Advanced Filter/Sort" and select the fields to be sorted. Right click and "Apply" when you have completed your selection.

 

[Nowell]

If your form is based on a query, then use the group by clause in SQL.

 

[aMember]

Thanks so much. Will try it out tomorrow.

 

[Golom]

Nowell

Did you mean "ORDER BY" rather than "GROUP BY"?