Restricting the number of items in a combobox

[odrap]

I like to manage some records in a table, based on the date the record was entered. Therefore, I use a combobox with a query based on this table as rowsource . The only field in the query is the field that holds the date the order was entered. A lot of these records are entered on the same date,and so, a lot of selectable items of the combobox displays the same date. The goal is to restrict the itmes so that each different date is only once displayed. I grouped by date in the query, but the result remained the same. In the SQL string i added "Distintrow",but also that didn't solve the problem. What to do in order to see each different date only once?

 

[Husan]

wat does yr SQL string look like?
it should be something like:

SELECT DISTINCT TableName.dateField FROM TableName;

 

[gemma-the-husky]

the distinctrow qualifier does what it says, but if your query has more fields than just the date, you are still likely to get duplicate dates, because the "whole row" is different from the other rows

 

[odrap]

Thank you for the help

 

[odrap]

The date field is the only field in the query