Form creation

[Guest]

I have a table with the following fields -
Proddate, qtyProduced.

On the form, I have the following text boxes -
Units, Working_sat, Shift_sat, working_sun, Shift_sun

I am calculating the qtyProduced per shift using the
formula
units/No of working days*shifts

I then would like to populate the table with the following
and then display the same on the form for the user to
accept as is or make necessary changes...

October (eg)
10/1 252
10/2 252...
.....
10/31 0

Another place that I get stuck is ...I am rounding the
calculation to get the units. But, in the end, how do I
add the difference (due to rounding) back to the units.

Thanks

 

[Geof Wyght]

You really should store units, No of working days, shifts
in your table. Or better yet Units, Working_sat,
Shift_sat, working_sun, Shift_sun.
Then on your form make qtyProduced a calculated field. I'm
not sure why you have No of working days and ProdDate. If
ProdDate is a single date then why should No of working
days be greater than 1?
Geof.