Data Entry based on dates

[islewis]

Hello,



I have a form that enters a transaction into my database. The user will input two dates: the start date and the end date. The transaction takes place each month. So for example: If the start date is 07/01/2014 and the end date is 12/31/2014 then I need 6 record entries. I am basically trying to decompose a calendar spread into separate transactions. It should be something like If startdate = #07/01/2014 Then If enddate = #12/31/2014# Then some sort of DoCmd to enter multiple records based on the user input data detailing the transaction. Maybe I need to set up a recordset? I am lost. Any help is appreciated. Thanks

[JeroenMioch]

You should use the DateDiff code like this :

Datediff("m",FirstDate,SecondDate)

Make three fields on your form, One startdate, one End date. Then the third holds the difference in dates (number of months).
You can make this field visible or not..

Then you make a command that makes new records at the amount of the third field.

[islewis]

I will give that a shot. How will that aid me in entering multiple records? Also, where would I add the datediff code? Or which property would this go in?

[JeroenMioch]

I will try to make an example when im at work tomorrow, ok ?