Re: Create a sorted table (DAO)
From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 12/06/04
- Previous message: Earl: "Re: SELECT * FROM table WHERE field = '%string%'"
- In reply to: Stefanie: "REQ: Create a sorted table (DAO)"
- Next in thread: Stefanie: "Re: Create a sorted table (DAO)"
- Reply: Stefanie: "Re: Create a sorted table (DAO)"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 6 Dec 2004 18:46:37 -0500
If you must have the data sorted, you have no choice but to use a query.
There's no such thing as a "sorted table" in relational databases. You can
never make any assumptions about the order of data in tables: they're "sacks
of data", with the data put wherever it fits.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Stefanie" <Stefanie@zsmail.net> wrote in message news:ubVv$552EHA.3132@TK2MSFTNGP14.phx.gbl... > Hi, > > I create a database using DAO with one table. > After that my app. stores data to this table. > But i need a sorted table to work with. Now i'am using a query, but with > about 4,000,000 records > it's time consuming (every time again). > Is it possible to sort this table once so i can use the sorted data every > time i needed. > > Regards, > > Stefanie > >
- Previous message: Earl: "Re: SELECT * FROM table WHERE field = '%string%'"
- In reply to: Stefanie: "REQ: Create a sorted table (DAO)"
- Next in thread: Stefanie: "Re: Create a sorted table (DAO)"
- Reply: Stefanie: "Re: Create a sorted table (DAO)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
