multiple records query

[darcy]

hi, i cant figure out the code to display only one of each record.

Each record has many colours and sizes so the database has the same item_code.

For a query to add new colours, im after the small command to only display each record once, and not all instances of it.

Hope this makes sense.

Any help would be greatly appreciated, thanks.

 

[chappy]

Use "SELECT DISTINCT item_code FROM [your table name here]". This will return a list of unique item_code values without any repeats.

Hope that helps.

-Chappy