random number

[maXim]

i want to pull records based on random sorting. i want that each time when
user asks for the report, the records are shown in different behaviour. how
can i apply it in my access database using VBA?

 

[Stefan Hoffmann]

hi,

i want to pull records based on random sorting. i want that each time when
user asks for the report, the records are shown in different behaviour. how
can i apply it in my access database using VBA?

Take a look at

http://www.mvps.org/access/queries/qry0011.htm



mfG
--> stefan <--