random selected records

[neskin]

hi there,
I am selecting for example 1000 records in group CD00 then
I have to split those records into 4 group with CD00A,CD00B,
CD00C and CD00D.
I can use TOP 250 but the problem is the number(1000) always changes when I run select query.
I was thinking to create a user defined function and pass
variable and do calculation but I don't know how
Is anyone has any ideas how to solve this problem

Thank you inadvance
Nat

 

[formerTexan]

Hi Nat,

I'm not clear on whether you are trying to return the same 1000 records each time or if your difficulty is somewhere else. But here is some general info.

The order in which records are stored is irrelevant to Access. Autonumber or primary key fields are used to uniquely identify records, not to keep them in any particular sort.

So your Select query will need to handle the sorting and/or selection criteria to return the desired set of records. IF your tables don't provide the information to make the necessary discrimination, then you will have to amend the tables.

IF you are looking for a more specific answer, then come back with some more details on what you are doing.

Cheers,
Bill