Creating Auto Fields

[f123 via AccessMonster.com]

Hi, how i can create new feilds on subform based on criteria on the main form.
Example:

Main form:
StartDate:01/01/2009
EndDate:31/12/2009
Rank:30

Subform:
should create new field for all the dates between 01/01/2009 & 31/12/2009,
like this
31/01/2009
01/03/2009
31/03/2009
...
...
31/12/2009

this new list should be different on each record based on startdate,enddate
and Rank
any help please

 

[KARL DEWEY]

Can not help without knowledge of your tables and field names with datatype
and relationships.

 

[f123 via AccessMonster.com]

thanks for your note, here i'll start again.

i have two tables "Database"&"Actual". the "database"consist of primery key
"S/No-Text","Start Date - Date","Duration-Number" and other records.

table " Actual" has Primary key "Autonumber", "S/No-Text", " Actual Date-
Date" and other records.

the relation is one (Database) to many (Actual).

also, i have Query1, where i get some calculated fileds from table "Database",
like "End Date", "Rank" and other records.

in the main form i have "Database" as a main form(Query1), and subform
"Actual" as Continuous Form.

now, for each record i have to create auto list for the field "Actual Date"
based on the "Rank" s following:
Record 1
StartDate: 01/01/2009
EndDate: 31/12/2009
Rank:30

that mean i need to create 12 dates for the field "Acual Date" between each
date is 30 days.

Record 2
StartDate: 01/01/2009
EndDate: 31/12/2009
Rank:20

that mean i need to create 18 dates for the field "Acual Date" between each
date is 20 days

is there any chance to help me on this

 

[Piet Linden]

thanks for your note, here i'll start again.

i have two tables "Database"&"Actual". the "database"consist of primery key
"S/No-Text","Start Date - Date","Duration-Number" and other records.

table " Actual" has Primary key "Autonumber", "S/No-Text", " Actual Date-
Date" and other records.

the relation is one (Database) to many (Actual).

also, i have Query1, where i get some calculated fileds from table "Database",
like "End Date", "Rank" and other records.

in the main form i have "Database" as a main form(Query1), and subform
"Actual" as Continuous Form.

now, for each record i have to create auto list for the field "Actual Date"
based on the "Rank" s following:
Record 1
StartDate: 01/01/2009
 EndDate: 31/12/2009
Rank:30

that mean i need to create 12 dates for the field "Acual Date" between each
date is 30 days.

Record 2
StartDate: 01/01/2009
 EndDate: 31/12/2009
Rank:20

that mean i need to create 18 dates for the field "Acual Date" between each
date is 20 days

is there any chance to help me on this

Sounds like you could do something like this
intDays = 365\intTimesPerYear
For dtCounter = dtStart To dtStop Step intDays

 

[f123 via AccessMonster.com]

Thanks Piet, but couldyou explain more to me, am new to access

where i have to use :
intDays = 365\intTimesPerYear
For dtCounter = dtStart To dtStop Step intDays

in the main form Events, Subform...