Auto Populate Based on Date

[Brian Paul]

Is it possible to select a start date and then an end date from a command
button. and then have access fill a table records. For example: If I select
Jan 1 2006 as the start and then select Jan 6 2006 as the end. I would end up
with the following records If I had a field named AppointmentDate in the
table.

Jan1 2006
Jan 2 2006
Jan 3 2006
Jan 4 2006
Jan 5 2006
Jan 6 2006

I know the record result would have to be formated that way in my above
result but that part Im not concerned with.

 

[Guest]

Yes you can use an append query. First create a table for reference with
numbers from 0 (zero) to your maximum expected date spread plus a few more.
In the append query add an output field that will append to your date field
like this --
New Dates: DateAdd("d",[YourNumberTable].[YourNumberField], [Enter start
date])

For criteria use this --
<=[Enter end date]