? create a list box based on a table but not seeign items twice

[lolita1]

Ok there is my question:

i want to create a list box to filter my forms. I want the list box to retrieve the date store in a table or query but it may have similar date in the table so i want the list box to show the date only once.

Thank you

 

[WildHare]

Base the list box on a query that does an ORDER BY the date guy. You'll get only one entry for each date, no matter how many there may be of "1/5/04", for example.

PS - say hello to Vladimir for me..


Jim

Don't be sexist - Broads hate that.
Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm

 

[JonFer]

I think WildHare meant to write that you should use GROUP BY with the date field. I would use "Select Distinct DateField from YourTable" as the listbox RowSource because you don't have any aggregate functions in your SQL.

 

[WildHare]

Indeed, JonFer, GROUP by, not Order by. My bad..

J

Don't be sexist - Broads hate that.
Another free Access forum:

http://www.forumco.com/jmhare

More Access help stuff at

http://www.jmhare.com/wildhare.htm