Query

[pl456]

Does anybody know how I could achive the following. Example table would hold say employees with various job titles, what I would want are results listing 2 staff members for each job title.

 

[dkinley]

You might want to take a look at the following thread ...

http://www.access-programmers.co.uk/forums/showthread.php?t=155152

This thread outlines and explains how to return two random items in a group. It also has a demo attached.

-dK

 

[pl456]

Thanks for that, although a little complicated for what I want to achieve it did get the mind working and I came up with a fairly simple solution using uinion queries and selecting the top 2 records.

Cheers

 

[dkinley]

I had never done what you were asking for but recalled seeing that thread once.

I am glad it was able to get you going.

-dK