--- whoisquilty <[EMAIL PROTECTED]> wrote: > James - I tried your first option (which suits my needs best) and it > tells me that it "can't group on popular". I also tried a few > variations but it still gave the same results. > > Is that the right column to be grouping? Or should I be grouping > 'vidno' as that's the one that I'll be using to join other tables? > > Jeremy
Yes, vidno is the one to GROUP BY. I guess you have another column which includes the date-time? Your table field list seemed incomplete. James
