Another Where clause problem

[qdogfball]

I probably just need to put my glasses on, but I cannot figure this out!

I am trying to gather 5 of each associates records and put them into another table.

The table temp gets randomized. It also has around 40,000 records.

There are 36 associates in tblAssociates.

    strSQL = "SELECT TOP 5 * INTO tblTempAuditWork " & _
             "FROM tblTemp " & _
             "WHERE tbltemp.USR_NME IN(SELECT ID FROM tblAssociates)" & _
             "ORDER BY tblTemp.RandomNumber;"

 

[pbaldy]

You won't end up with a space between the subquery and "ORDER...".

 

[qdogfball]

Haha!

Well that solved getting some information.

But, I only got 5 records total, not 5 from each associate.

36 associates * 5 records = 180 total records.

Would I have to step through the tblAssociates in a DO LOOP?

 

[pbaldy]

One way:

http://support.microsoft.com/kb/210039/en-us