List dates in the query, instead of typing them...............

[Guest]

In the query, I setup a parameter to choose the date you want to see. Is
ther any way that I can have a drop down list of all the dates in the field?

Thanks for the help.

 

[Graham R Seach]

Tony,

You have to create a form to do that. The form would contain a combo box or
list box containing all the relevent dates.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[John Vinson]

In the query, I setup a parameter to choose the date you want to see. Is
ther any way that I can have a drop down list of all the dates in the field?

Thanks for the help.

You can create an unbound Form (frmCrit let's call it) with a Combo
Box cboDate on it; set the combo's Row Source to a query

SELECT DISTINCT datefield FROM table ORDER BY datefield;

Use as a parameter

=[Forms]![frmCrit]![cboDate]


John W. Vinson[MVP]