If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form creation
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 |
#2
|
|||
|
|||
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. -----Original Message----- 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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple record creation through a form | Graham Daniels | Using Forms | 4 | September 11th, 2004 11:28 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |