Search results

Let me first say I am a self-taught novice when it comes to databases so please take that into consideration when you read and reply:). I am creating a MS Access 2013 database to track calls, questions, assignments and other related work for my human resources department. We will lump all types...

Okay vbaInet here is the code for what you have been suggesting (I think)...I created three separate queries to randomize all records in each table. qryRandAnimalsStep1 SELECT Animals.AnimalID, Animals.AnimalName, Rnd([AnimalID]) AS Expr1 FROM Animals ORDER BY Rnd([AnimalID]) DESC...

VS means verses as in -- this verses that or this vs. that. I will see what code I come up with trying what you suggest.

vbaInet -- How about sharing the code to do what you are saying? I thought I understood the difference between what I was doing and what you say I should do and said that in my post, except you seem to have stopped reading before the VS. Please explain with code so I can compare it to mine and...

Jdraw -thanks for this example. I only have one problem with it ... The nice code that does the randomizing is not something I know how to do. Is that vbscript? I think I understand the concept and will try doing it using Access SQL and design view which I am getting to know.

I think I understand what you are saying about getting the top records and then sorting them in random order vs. sorting the table in random order and then picking the top records from that sort. I'm still trying to figure out the code to do that but what you are saying makes sense. Thanks for...

bob fitz: Thanks for the link to the Len function it is very helpful for more than just this question.

I want to thank everyone for their suggestions (Bob Fitz - I changed my field name based on your suggestion - thanks should have know it was reserved). I'm just a beginner so this is all very enlightening even if some of it is still over my head. Sorta teaching myself as I go using what I find...

I am fairly new to Access 2013 but am trying to create a query that will select random records from three totally unrelated tables and display the results together as if one table -- think video slot machine wheels. Each table has two fields - ID which is the primary key and NAME. The data in...