Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-24-2000, 08:00 PM   #1
WILSON
Guest
 
Posts: n/a
calculated fields

I have a field in a form that subtracts one time from another in the form but it does not show up in the table. i am wondering if i have not created the table correctly

  Reply With Quote
Old 04-25-2000, 06:09 AM   #2
Andy Dawes
Guest
 
Posts: n/a
Does it need to appear in the table? You could simply calculate the value every time you needed it.

I have had a similar problem and have used Update Queries to overcome it. However these can be slow if you have loads of data and updates the whole column every time.
  Reply With Quote
Old 04-26-2000, 03:13 PM   #3
jaydlewis
Junior Member
 
Join Date: Apr 2000
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
jaydlewis
It is not usually a good idea (good db design) to store calculated values.

jaydlewis is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 07:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World