Search results

  1. K

    Select n random records per group

    I think I'm getting close. I have the following so far using khawar's previous post. As I've stated it's one table and I just need random 5 of each UserID (text). ID below is an issue because ID is a primary key that is generated by access but I don't necessary want to be sorted by ID, rather...
  2. K

    Select n random records per group

    I hate to hijack a thread but I have a similar situation and I don't know where to begin. I hope some of you are still out there to help! Basically, I have a table with about 6 different fields, UserID, Date, transaction, etc. I need to generate a query that will provide me 5 random...
  3. K

    Hello Everyone!

    I'm just analyst trying to do somethings with access database. I usually work with data that are fairly extensive. It's been longer than 10 years since I've touched access so I don't know if I'll be any help but I'll try my best!
Back
Top Bottom