SubForm Calculation

[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

 

[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
(e-mail address removed)

 

[StopThisAdvertising]

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.

--
This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html
Until now 3300+ pageloads, 2200+ first-time visitors (these figures are rapidly increasing)

To PCD' Steve: (this is also to inform those who do not understand...)
This is *not* about the sigline...(although you are far away from a 'resource' status).
But we will simply continue to hunt down *each and every* of your posts.

Why???
Because you are the ONLY person here who continues to advertise in the groups.

It is not relevant whether you advertised in *this* particular post or not...
==> We want you to know that these groups are *not* your private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR