I'm doing multitasks which involve use of top 50 percent based on random number of ID.
I select any records with Form Value "Mike".
Please see 2 databases attached:
1) In database 2.1 I create temp table "temp table-top 25 percent random id" by selecting 50% random numbers of ID from "table2" and using sort of random numbers. This is done in Query 1. In the Query 2, I select a record with Name "Mike" and exclude results from the temp table. The correct output is 1 record
2) In database 2.2 I'm doing same thing by using queries only. This provide incorrect results of 3 records
1. Can I modify Database 2.2 so I can use "queries only" approach and get correct results.
Note: I have to be sure that records which I exclude based on 50% from random number sorts of ID.
Relevant information: main table is "table2"
Name stored in the field "Form Value"