Hi Everyone,

Im having a problem with displaying distinct records.

I have a posters db which contains serveral fields with categories, and sizes.

The problem is they all have a size, but may belong to 1 or more categories. Which is fine sorting by category but when they are view the products by their sizes it produces duplicates.

Is it posible to Use the DISTINCT on a specific field. In this case by product_name because it does not work just using the DISTINCT

HERE IS MY SQL Statement

strSQL = "SELECT DISTINCT product_id, product_type, product_size, product_code, product_name, product_cat FROM products ORDER BY product_name"

Thanks Tim

TDA

__________________
TDA

Hi Tim,

Try using GROUP BY - you can "group by" more than one field if you need to...

Will a product with miltiple categories have different sizes or just the one size? If not, then I suggest you put product categories in a seperate table to save duplicating product details in products. (it will also solve this problem for you)

cheers,

Paul