Auto Calculation

rocky09

Registered User.
Local time
Today, 15:53
Joined
Nov 21, 2012
Messages
51
Hi there,

I am newbie in Access. Can any one please help me on this Situation.

I have two Tables.

TimeCalstble:

FileType esttime
Dzz 0.15
Dui 1.25
Zui 1.52


Dailydeliverablestble:

Name FileType Processed overalltime
ramiz Dzz 10
Sumit Dzz 5
kriti Dui 25

So, I need Multiplication vales in "overaltime" column. In other way, it should calculate the Processed * estime from the other table.

is it possible?

Thank you inadvance,

Best Regards,
Arjun
 
Calculations should not normally be saved in a table field but done in a query and recalculated whenever and wherever they are needed.
 
Calculations should not normally be saved in a table field but done in a query and recalculated whenever and wherever they are needed.


hey Bob,

Thank you so much for your reply. Is there any sample file available? as I said, I am newbie to the Access.

Best Regards,
 
Arjun, Welcome to AWF :)

You do not have to store calculations in Tables, you only need them in Queries. Check out Allen Browne's take on the issue : http://allenbrowne.com/casu-14.html

PS: Sounds like you are from India, is that right?

EDIT: Looks like I was too slow there. :p
 
Last edited:
Arjun, Welcome to AWF :)

You do not have to store calculations in Tables, you only need them in

PS: Sounds like you are from India, is that right?

EDIT: Looks like I was too slow there. :p

Hi,

Thank you very much for your reply. Yes. I am from India. BTW, can we achieve through Forms?

Best Regards,
Krrish
 
BTW, can we achieve through Forms?
Forms - Yes, on one condition, and one only. This will be an UNBOUND Control. There is absolutely no need to store this value, as this can be obtained when and where required. You'd use a Query as,
Code:
SELECT yourTable.Firstcolumn, secondColumn, yourTable.Firstcolumn * yourTable.secondColumn As yourCalcColumn
FROM yourTable;
Hi,
Thank you very much for your reply. Yes. I am from India.
:
Best Regards,
Krrish
Cool, One fellow brother to another.. Arjun or Krrish? ;)
 
Forms - Yes, on one condition, and one only. This will be an UNBOUND Control. There is absolutely no need to store this value, as this can be obtained when and where required. You'd use a Query as,
Code:
SELECT yourTable.Firstcolumn, secondColumn, yourTable.Firstcolumn * yourTable.secondColumn As yourCalcColumn
FROM yourTable;
Cool, One fellow brother to another.. Arjun or Krrish? ;)

Thank you so much. Full name is Krishna Arjun. :)
 
No problem ! Good luck with your project, don't think twice if you need help.

PS: Once you hit up 10+ posts, send me a PM. :)
 

Users who are viewing this thread

Back
Top Bottom