A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

A calculation in a form



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2010, 09:38 PM posted to microsoft.public.access.forms
debt
external usenet poster
 
Posts: 1
Default 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)
Ads
  #2  
Old May 25th, 2010, 10:02 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default 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  
Old May 27th, 2010, 10:02 PM posted to microsoft.public.access.forms
Weeble[_2_]
external usenet poster
 
Posts: 27
Default 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  
Old May 27th, 2010, 10:52 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.