Auto Populate Based on Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian Paul - 27 Sep 2006 21:37 GMT

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.

Reply to this Message

KARL DEWEY - 28 Sep 2006 05:08 GMT

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]

> 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
[quoted text clipped - 11 lines]
> I know the record result would have to be formated that way in my above
> result but that part Im not concerned with.

Reply to this Message