Auto Calculation

[rocky09]

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

 

[bob fitz]

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

 

[rocky09]

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,

 

[pr2-eugin]

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.

 

[rocky09]

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.

Hi,

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

Best Regards,
Krrish

 

[pr2-eugin]

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,

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?

 

[rocky09]

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,

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.

 

[pr2-eugin]

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.

 

[rocky09]

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.

Thank you again. Sure Bro.