List of Dates

[mugman17]

I have a form that refers to another table of dates. It looks at this other table and figures out have dates are in between a Start Date and End Date.

I have it so they are counted using the DCount function. Now I would like to list the dates in a text box in this format.

10/20/2001, 11/04/2002 etc.

Can this be done?

 

[chrismcbride]

You could set up a loop through either the recordsetclone of your form or a recordset that you populate using a SQL statement. You would insert the recordset value, a ";", move to next recordset value etc.
However I think a simpler option would be to use a listbox. You could set the controlsource of the box to take into account the Start and End Dates, however you get these..
HTH
Chris