Search results

That works, thanks Paul. My next problem is I need to be able to explain this to a group of kids :( If anyone knows a way to get this same effect without going into sql I'd really appreciate it.

Table Name - Music Field Name - "ID", Type - "Autonumber" - Primary key Field Name - "Band", Type - "Text" Field Name - "Single", Type - "Text" Field Name - "Sales", Type - "Integer"

Thanks Paul. I tried that, but it doesn't work. It still returns all the records from the original table. I only want the highest selling single from each band. I have been able to create a query with two fields - band and sales, and using "group by" for band and "max" for sales it does...

Hi Guys, Hopefully a nice easy question here. I have a single table database. It contains the fields "Band", "Single" and "Sales". Band contains the name of a band, single contains the name of a single released by that band, and sales is the number of copies of that single which was sold...