I am recieving duplicate entries from a table in my query using the Min option in total section.
I have a table with a list of styles and unique numbers eg
Style Number
1234 104501
1234 104502
1234 104503
4321 109701
4321 109702
In a query prior to the main query I am saying that I want the 'number' for 2 records of style 1234, this information is inputted through a form linked to a seperate table.
The main query, using 'Min' in totals, this is pulling out results for 2 records of style 1234 but it showing number 104501 for both records. I need it to show 104501 for the first record and 104503 for the second record.
It is important that it picks the lowest number first, and I have to be able to select more than 1 entry of the same style at the same time, so i can't just say give me result for 1 'number' for style 1234 and 1 'number' for style 4321. In the SQL view I have added DISTINCT after select.
Any ideas how I can get the query to display the information I require.