Microsoft access Update Datediff

Question

I need to do a simple update where I update the "Days" column with the current date value minus the "Opening Date" column".

"UPDATE tblPendencia SET DiasPendentes = (DATEDIFF(day, DATAABERTURA, DATE())) WHERE PendenciaOrigem = 'PM'"

I am running this query but it is returning me the error "No value Given for one or more required Parameters".

Thank you.

Answer 1

After some help...

UPDATE tblPendencia SET tblPendencia.Diaspendents = (DATEDIFF(’d', tblPendencia.Aberturadata, Now())) WHERE tblPendencia.Pendenciaorigin = 'PM'"