Data entry on Form and calculations made on that data

[jpkeller]

I am trying to create a form where the user enters basic data and then the form performs a series of calculations based on the initial data entry. An example would be best:

User would enter the following information which would vary from record to record(in red):

PatientID: 123456
StartingDate: 12/16/04
DateInterval: 7
StartDose:10
DoseIncreaseAmt: 4

I would like to see 5 series of data where the 7 (from the DateInterval) is added to 12/16/04 and 7 added to that date and so on until 5 dates are shown. For each date interval the dose increase amount is added to the previous value based on the (DoseIncreaseAmt). The output would look like the following:

Date:12/16/04___12/23/04___12/30/04___1/06/05___1/13/05
Dose:__10_________14________18________22________ 26

I assume this would be some sort of subform. I am not an experienced Access user so I appreciate any help you all may lend.

Thanks much, jpkeller

 

[MStef]

Hello jpkeller!
Look at "DemoDateDoseA97.mdb
(MStef alias Štef)

 

[MStef]

I forgot, put relationship between tables.

 

[jpkeller]

Thanks Stef, Works great!