Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

capture my random selection

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Val - 22 Oct 2005 07:28 GMT
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
Jeff Boyce - 22 Oct 2005 13:36 GMT
Val

?Save?  We're not there, so we can't see what you're trying to do.

Signature

More info, please ...

Jeff Boyce
<Office/Access MVP>

> 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
Val - 22 Oct 2005 14:14 GMT
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
>
[quoted text clipped - 6 lines]
>>
>> thanks
Jeff Boyce - 22 Oct 2005 16:32 GMT
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".

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> ah,
> i had a random query that runs selection from my table for top 30, rnd(
[quoted text clipped - 19 lines]
> >>
> >> thanks
Val - 23 Oct 2005 06:13 GMT
its okey thanks,,i just create a table and make append query to store ..
thanks again

>Val
>
[quoted text clipped - 15 lines]
>> >>
>> >> thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.