Recent content by jpanalyst

Thanks Mike, Appreciate the link and the advice.

Hey guys could use some of your help, I have a two tables containing similar information, which can be seen below. The table on the left has unique entries for peoples 'names', however two people can share the same 'GroupID' (for grouping reasons). I am looking to put a relationship between...

I need to run a query that will select the top field in each case. I have repeat entries of an ID with a count but I would like it to select one of those entries at random rather than selecting all of them. e.g. My table looks like this:- ID: 00001 Count: 6 Place: New York ID: 00001 Count...