Hi,
I should, and did know the solution to this problem, but have forgotten!
I have a query to sift a table and only retreive certain records (item colour to be exact - for use in a selection combo box). However, I have the classic problem of duplicate records - i.e. there are multiple records in the table with the same colour field value, and I want to prevent this, and only have each colour once. I know this is possibe by adding another query but this is going a bit OTT - and I'm sure there's another way?
Any suggestions welcomed...
kdm3
I should, and did know the solution to this problem, but have forgotten!
I have a query to sift a table and only retreive certain records (item colour to be exact - for use in a selection combo box). However, I have the classic problem of duplicate records - i.e. there are multiple records in the table with the same colour field value, and I want to prevent this, and only have each colour once. I know this is possibe by adding another query but this is going a bit OTT - and I'm sure there's another way?
Any suggestions welcomed...
kdm3
