Random Records

  • Thread starter Thread starter Robbie
  • Start date Start date
R

Robbie

Can someone tell me how to return random records from a
table? I used the Knowledge Base article 208855 the
problem with this was once you close the application, then
go back into it it used the same order...anyhelp is
appreciated
TIA,
Robbie
 
the
problem with this was once you close the application, then
go back into it it used the same order
Click to expand...

A Table HAS NO ORDER. You can't sort it, randomly or any other way.
Access will store the records wherever it finds convenient.

If you want to see the records in a particular order, you must - no
option! - look at a Query rather than looking at your table.
 
So for my vagueness on this topic. I assumed from me
posting the KB Article # that someone who was familiar
with it would respond therefore knowing that the question
I posted was based on a query not a table...no matter
though I have found a solution from another site...thanks
anyhow
 
Back
Top