Sortering af tabel

If you make  a query you can sort by the date field and then the time field.
I am not sure what you mean by \"afhængigt af dato-feltet\".
The is more than likely more than one record in th etable, and you cant change the sort order for each record. But you could change the sort order for the whole query in code.

Opret et index på tidsfeltet. Derved vil Access sortere på dette felt også.

\"afhængigt af dato-feltet\", means: dependent on the date-field! ;)
Nej, bare at de enkelte poster først er sorteret på dato, dernæst på tid.
Dato      Tid
1/1-02    12:23
1/1-02    12:23
1/1-02    12:21
31/12-01  11:23
31/12-01  11:15
Sort by date, then by time, but NOT in a query, directly in the table. That\'s not possible, is it?

Jo, hvis du laver et index på Tid i tabeldesign, som jeg skrev....

try what Thomas suggests. But you can also sort in the form in the order by property

Well, terry, thomas had the correct answer this time, sorry, but you\'ll get a 3p for answering so fast.

Mærkeligt, tid VAR indekseret, dato var ikke, da dato blev rettet, virkede. hmmmm....;(

thanks but that wasnt necessary, Thomas did give you the answer you wanted :o)

Nu kan jeg se, at du gerne vil sortere faldende. Så skal du gøre følgende:
I Tabeldesign, kan du åbne \"Indekser\" vha menuen Vis->Indekser
Her kan du angive de kolonner, som skal indekseres og herefter om det skal vare stigende eller faldende.

That\'s true, damn it, can I reclaim the 3p\'s????
;) ;)

yes if you want :o)

Det har du da ret i, thomas, tak for fif\'et!

puppetmaster>If You have other indexes on your table, or for example time is before date then you wont (I dont think) be able to sort like this.
Another thing: You can make a combined index containing the date and time, but as I said its not going to help much if for example you have and ID as your primary key!