S
Sharon
I have a database for travel expenses. One of my tables is tblTrips. I have
created one field in the form for TripStartDate (using the MS Date & Time
Picker Control Version 6.0) and another field for TripEndDate (using the MS
Date & Time Picker Control Version 6.0). I need to calculate the expenses,
i.e., breakfast, lunch, dinner, cab, etc. for EACH day. I have a subform
with all the expenses for each day, but I need to generate a record for each
day in between the dates specified as TripStartDate and TripEndDate
automatically. Each trip will have a different amount of days. For example,
if the TripStartDate was 01/01/05 and the TripEndDate was 01/15/05, I need to
calculate the number of days between the days and then return a record, which
includes the daily expenses, for Jan. 1, Jan. 2, Jan. 3, etc. for example.
Thanks for any help.
created one field in the form for TripStartDate (using the MS Date & Time
Picker Control Version 6.0) and another field for TripEndDate (using the MS
Date & Time Picker Control Version 6.0). I need to calculate the expenses,
i.e., breakfast, lunch, dinner, cab, etc. for EACH day. I have a subform
with all the expenses for each day, but I need to generate a record for each
day in between the dates specified as TripStartDate and TripEndDate
automatically. Each trip will have a different amount of days. For example,
if the TripStartDate was 01/01/05 and the TripEndDate was 01/15/05, I need to
calculate the number of days between the days and then return a record, which
includes the daily expenses, for Jan. 1, Jan. 2, Jan. 3, etc. for example.
Thanks for any help.