sorting table

[winjohan]

sorting table (solved)

Hey there

Is it possible to sort a table on a specific field
lets say custumer_name
and what should i do to make it work

thanks in advance
Johan

 

[FoFa]

Data is not stored in any special order (for the most part) in a database. You can write a query to pull the data and sort it so it appears sorted. You can use that query in reports and forms to see the data sorted.

 

[winjohan]

Hello Fofa

Thanks for your replay

I know i can sort it in a query but is there a way i can sort it directly in the table
I saw a option in the tabledesign (F4)
option sorting i gues but what has to be filled in to make it work

Thanks in advance
Johan



Oke found it :
Sorting:
tblTableName.FieldToSortOn