Auto incrementing date

[rashidaa]

How can I auto increment date in MS Access.

I have a form in which I collect following data
Range: From >> to
Start Date:

Now I wish to populate/append a table after I specify the start date and range For example if I specify range from 9 to 15 and give start date 24/10/2007 I wish the table to populate as-

No Date
9 24/10/2007
10 25/10/2007
11 26/10/2007
...
...
15 30/10/2007

How to DO it MS Access

[NeoPa]

You will need to process this using a RecordSet in VBA code.
SQL (queries) tends to work on existing data and as you have no existing data that can help, you'll need to use the code. If, for instance, you wanted to create records exactly 1 week forward from your existing records (or a subset of them) you could handle it in SQL but that's because the requirement is relative to existing data.
In your code have a loop which increments the data value then create a record in the table for each one.

[rashidaa]

Thanks for the reply. However I already have data and I wish to do this through SQL. Infact I am able to generate a table with

8 21/10/2007
9 21/10/2007 but i wish it to be 22/10/2007
10 21/10/2007 23/10/2007
...
...

I am unable to write proper SQL for this

[NeoPa]

You will need to process this using a RecordSet in VBA code.
SQL (queries) tends to work on existing data and as you have no existing data that can help, you'll need to use the code. If, for instance, you wanted to create records exactly 1 week forward from your existing records (or a subset of them) you could handle it in SQL but that's because the requirement is relative to existing data.
In your code have a loop which increments the data value then create a record in the table for each one.

The explanation of why the first sentence is true is merely that. An explanation. It seems you are having difficulty following that but it doesn't matter. Just go by the first sentence. The second paragraph explains how you need to start going about it.