Random Records

[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

 

[John Vinson]

the
problem with this was once you close the application, then
go back into it it used the same order

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.

 

[Robbie]

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