I belief this will solve ur problem. Note that Its always good also to restrict ur users to valid entries in this case U can use a combobox to collect only valid dates existing by setting the rowsource to the field in the table.
I also wonder what ur reason is to Group the query because if u a...
I am a new member. Akinwale from Osun State, Nigeria. I av been using MS-Access for about 14 years now, I like logical reasoning and intelligence, I like to learn and develop. I am very frank and observant.