I have a table with two fields. In one field is a company name and in the 2nd is a booth number. Multiple records can exist with the same company name, but only one can exist with any given booth number, So basically company XYZ can have booths 1,2,3 and 4 but they're all separate records. I tried to use the group by clause to put these all together, but I can't seem to get it working right. Here's what I've got and it keeps giving me an aggregate error message. Can anyone help me on this one? Thanks.<BR><BR>sql = "SELECT EXHIBITORS, BOOTHS FROM BOOTHS GROUP BY EXHIBITORS"