Microsoft access Update DateDiff

Navigation
1

I need to make a simple update where I update the column "DiasPendentes" with the value of the current date minus the date of the column "DataAbertura". 

"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.

    
asked by anonymous 19.12.2016 / 21:37

1 answer

2

After some help ...

UPDATE tblPendence SET tblPendency.DiasPendents = (DATEDIFF ('d', tblPending.AberturaData, Now ())) WHERE tblPendencia.PendenciaOrigem = 'PM' "

    
19.12.2016 / 22:31
Automatic view of a selected row Capture values from one table and insert them into another table