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
|
|||
|
|||
A calculation in a form
The form I use to enter purchasing data calculates a total cost per order,
but it doesn't put this info into the data table. How do I get it to do this? (All the other data from the form goes to the corresponding field in the table) |
#2
|
|||
|
|||
A calculation in a form
Unless there is some business reason, (like say for audit purposes) you never
store calcualtions. They just take up space and memory. Instead, maybe try putting the calculations in a query and refernce the query from your form so that every time you run the form it gives you fresh calculations. -- Milton Purdy ACCESS State of Arkansas "debt" wrote: The form I use to enter purchasing data calculates a total cost per order, but it doesn't put this info into the data table. How do I get it to do this? (All the other data from the form goes to the corresponding field in the table) |
#3
|
|||
|
|||
A calculation in a form
As previously stated, ideally you wouldn't store calculated data, however if
you still feel you need to store this information it is pretty straight forward: Table.Field = Forms!YourFormHere!FormControlHere "debt" wrote: The form I use to enter purchasing data calculates a total cost per order, but it doesn't put this info into the data table. How do I get it to do this? (All the other data from the form goes to the corresponding field in the table) |
#4
|
|||
|
|||
A calculation in a form
Debt -
For a form field (control) to get saved to the database, it must be bound to a field in the database. -- Daryl S "debt" wrote: The form I use to enter purchasing data calculates a total cost per order, but it doesn't put this info into the data table. How do I get it to do this? (All the other data from the form goes to the corresponding field in the table) |
Thread Tools | |
Display Modes | |
|
|