How to use DateDiff in calculated field in access

ms-access calculated-columns calculated-field
user1181942 picture user1181942 · Dec 8, 2017 · Viewed 8.5k times · Source

I am trying to get "No of days late" in a particular table in MS access. I am trying to use calculated data type.

I have [ActualReturnDate] and [ReturnDate] in the same table (both are Date/Time) and I want to save difference between two columns in a calculated field.

I am using following expression:

DateDiff("d", [ActualReturnDate] , [ReturnDate] )

But no matter what i do I get error saying "The expression X cannot be used in a calculated column."

So does that mean I cannot use DateDiff in Calculated field? If not how should I do it?

Answer

Rene picture Rene · Dec 8, 2017

You indeed can't do this in a calculated field. Use a query instead, add a column and do the calculation in that column.

Related questions

How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More
How to SUM two fields within an SQL query

I need to get the total of two fields which are within the same row and input that number in a field at the end of that same row. This is my code. Sum(tbl1.fld1 + tbl1.fld2) AS [Total] …

Read More
Code to loop through all records in MS Access

I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also possible to loop through filtered records and, again, extract data? Thanks!

Read More