Calculated fields

**puuts** · 07-31-2014, 10:48 AM

Hello Gurus,

I have two columns in my database:

Please Login or Register  to view this content.

I have a formula in calculated field:

Please Login or Register  to view this content.

the result always return 12:mm:ss tt

for example:

Please Login or Register  to view this content.

I just want to display the exact result which is:

Please Login or Register  to view this content.

**alansidman** · 07-31-2014, 08:16 PM

You have posted in the Access forum. Is this an Access issue or an excel issue?

**puuts** · 07-31-2014, 10:19 PM

Originally Posted by alansidman

You have posted in the Access forum. Is this an Access issue or an excel issue?

hello alan,

this is an access issue.

**alansidman** · 07-31-2014, 10:37 PM

Ok, then. Although recent versions of Access allow you to have calculated fields, it is not a good practice. If data changes, then you need to do a re-calculation of every record affected. You are better served to do your calculations in a query or in a form to assure up to date information. Look at this link on Allen Browne's web site about calculations in tables.

http://allenbrowne.com/casu-14.html#CalcFieldA2010

If you wish to calculate in a query, then your issue may probably be resolved using the DateDiff function. Look at this link for an explanation on how to use the DateDiff function

http://www.techonthenet.com/access/f...e/datediff.php