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

T

Tony

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.
 
G

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
 
J

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.
Click to expand...

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]
 
Top