capture my random selection

  • Thread starter Thread starter Val via AccessMonster.com
  • Start date Start date
V

Val via AccessMonster.com

Hi,

Is there any way i could save my random selection?...My random selection
query is working fine i just want to save it..


thanks
 
ah,
i had a random query that runs selection from my table for top 30, rnd(
[partid]) it works fine but i need to save or capture it. Is it possible?..by
the way am just beginner from access.my query grid is:

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

my bad i did not clarify...thanks
 
Val

I'm still not clear on "save or capture".

If you only need to know which ones were selected, you could print the query
results.

If you are saying you'll need a specific list (each time you run the query,
you should be getting a different/random list), you could convert the query
to a Make-Table query. But if you'll need to keep more than one such list,
you'll need to create a table you'll use to store the lists, you'd append
the query results to that table, AND you'd have to somehow identify each
separate "run".

--
Regards

Jeff Boyce
<Office/Access MVP>

Val via AccessMonster.com said:
ah,
i had a random query that runs selection from my table for top 30, rnd(
[partid]) it works fine but i need to save or capture it. Is it possible?..by
the way am just beginner from access.my query grid is:

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

my bad i did not clarify...thanks

Jeff said:
Val

?Save? We're not there, so we can't see what you're trying to do.
Click to expand...
Click to expand...
 
its okey thanks,,i just create a table and make append query to store ..
thanks again

Jeff said:
Val

I'm still not clear on "save or capture".

If you only need to know which ones were selected, you could print the query
results.

If you are saying you'll need a specific list (each time you run the query,
you should be getting a different/random list), you could convert the query
to a Make-Table query. But if you'll need to keep more than one such list,
you'll need to create a table you'll use to store the lists, you'd append
the query results to that table, AND you'd have to somehow identify each
separate "run".
ah,
i had a random query that runs selection from my table for top 30, rnd(
Click to expand...
[quoted text clipped - 19 lines]
Click to expand...
 
Back
Top