how to save random selection

[mike via AccessMonster.com]

Hi,

I had a random query for top 30 items it works fine. Is there any way i can
save this random selection that i have?.My random query format on grid is
like this:


field: tblCatalog.* Expr1: Rnd([part_id])
sort Ascending
Criteria
or:

thank you

 

[Guest]

Mike,

Use an Update query to set a field to your expression.

 

[mike via AccessMonster.com]

thanks

Mike,

Use an Update query to set a field to your expression.

Hi,

[quoted text clipped - 8 lines]

thank you