PC Review


Reply
Thread Tools Rate Thread

Calculations on Form bound to a field in a table

 
 
=?Utf-8?B?V2lsZGx5SGFycnk=?=
Guest
Posts: n/a
 
      31st May 2007
Is possible to perform calculations in a field and have them stored in a
table? For instance I have a call log form where users enter different types
of calls that they recieve. the fields that they enter are bound to a table
that tracks the calls. I can place formulas in the form that display the
totals of the different calls. Can I have those totals bound to a field in
my table?
 
Reply With Quote
 
 
 
 
RBear3
Guest
Posts: n/a
 
      31st May 2007
If the numbers that make up the calculation are already in the table, then
you don't need to also store the total. It is redundant. When you need the
calculated value, just calculate it. It is more efficient and you don't
have to worry about changing the total if you go in and change one of the
values that is included in that total.

Database normalization rules would say that you don't store calculated data
in a table.

--
Hope that helps!

RBear3
..

"WildlyHarry" <(E-Mail Removed)> wrote in message
news:E523483E-E505-4455-BA8D-(E-Mail Removed)...
> Is possible to perform calculations in a field and have them stored in a
> table? For instance I have a call log form where users enter different
> types
> of calls that they recieve. the fields that they enter are bound to a
> table
> that tracks the calls. I can place formulas in the form that display the
> totals of the different calls. Can I have those totals bound to a field
> in
> my table?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add field to report from the bound table? =?Utf-8?B?ZWxlbmE=?= Microsoft Access Reports 1 18th Jun 2007 08:06 PM
How to make a form field bound to a table equal a calculated fie =?Utf-8?B?QmlsbHNBY2Nlc3M=?= Microsoft Access Forms 1 7th Feb 2006 02:39 PM
How to make a form field bound to a table equal a calculated fie =?Utf-8?B?QmlsbHNBY2Nlc3M=?= Microsoft Access Forms 1 7th Feb 2006 01:03 PM
How to make a form field bound to a table equal a calculated fiel =?Utf-8?B?QmlsbHNBY2Nlc3M=?= Microsoft Access Forms 1 7th Feb 2006 12:42 PM
Bound query field using an autonum field from bound form =?Utf-8?B?SmltQw==?= Microsoft Access 1 10th Mar 2005 05:40 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:49 PM.