SubForm Calculation

M

misschanda

Hello,

I have a subform w/ the following field names

trial number
draw1
draw2
draw3
speed1
speed2
speed3
speed4


speed 2 is equal to draw1 * speed1
speed 3 is equal to draw2 * speed2
speed 4 is equal to draw3 * speed3

how do i represent this in the form. I have tried a query however, but the
calculation stops at speed2.

Thanks
misschanda

I made a query to d
 
S

Steve

You should have a table with the following fields:
trial number
draw1
draw2
draw3
speed1

speed2, speed3 and speed4 are calculated values and should not be strored in
the table.

Create a query based on your table. Pull in the fields:
trial number
draw1
draw2
draw3
speed1

Put the following expression in the first blank field of your query:
speed2:[draw1] * [speed1]


Put the following expression in the next blank field of your query:
speed3:[draw2] * [speed2]

Put the following expression in the next blank field of your query:
speed4:[draw3] * [speed3]

The above assumes that draw1, draw2, draw3 and speed1 all have values. If
that is not the case, you need to include the NZ function in the above three
fields on the right hand side. Look up NZ function in the Help file.

Now you can include all the fields from your query in your form.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Top