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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

calculations in form are not entered into appropriate table



 
 
Thread Tools Display Modes
  #1  
Old May 9th, 2005, 02:18 PM
TLM_QA
external usenet poster
 
Posts: n/a
Default calculations in form are not entered into appropriate table

Calculations entered into property control source is not entered into the
appropiate table field. Show up as $0.00
  #2  
Old May 9th, 2005, 02:35 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default

TLM_QA wrote:
Calculations entered into property control source is not entered into
the appropiate table field. Show up as $0.00


A control is bound to a field in the table by entering a field name (and
just a field name) as the ControlSource property of that control. If you
have entered an expression as the ControlSource then it is no longer bound
to a field and there is no mechanism to get that value stored into the
table.

The good news is that calculations are not supposed to be stored in your
tables anyway. Just use the calculation that you already have on the form
anywhere you need that value displayed. If you don't want to enter the
expression multiple times then build a query based on your table and add the
expression as a calculated field in the query. Then just substitute the
query every place that you ordinarily use the table.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


  #3  
Old May 9th, 2005, 02:38 PM
Rick B
external usenet poster
 
Posts: n/a
Default

You don't store calculations in a table. What if one of the fields that
makes up that calculation changes? How would access know to update the
calculated field?

When you need the calculated value, claculate it in your form, report, or
query.

For more details, read the previous posts on the topic. This is asked and
answered all the time. Do a search.

--
Rick B



"TLM_QA" wrote in message
...
Calculations entered into property control source is not entered into the
appropiate table field. Show up as $0.00



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to clear controls of Filter form Jan Il Using Forms 2 November 28th, 2004 03:04 PM
Default values to load up automatically in a form based on value entered in another form Anthony Dowd Using Forms 8 August 12th, 2004 08:53 AM
dlookup miaplacidus Using Forms 9 August 5th, 2004 09:16 PM
Recordset in subform based on field in parent form Lyn General Discussion 15 June 14th, 2004 03:10 PM


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


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