error in updatequery

[mohamedmatter]

i create update query to update fieldname DateOfTraining to 1/1/1999 but display error in query Group_A 30/12/1899 where error
i attach simple database

 

[mohamedmatter]

You can update a table but NOT a query.

error display in table also i attach image from table

 

[arnelgp]

replace your Update To field with:

IIf(Nz([DateOfTraining],0)<#1/1/1999#,#1/1/1999#,[DateOfTraining])

 

[Gasman]

You update tables, not queries?

 

[JHB]

The same was my immediate response, but you can actually update a query, which then writes the values in the table. Therefore I deleted my response, but apparently not fast enough because OP had seen it.

 

[JHB]

The problem is that there are some minutes value in the "DateOfTraining" field.
Therefore the update query doesn't update because it has the criteria "IIf([DateOfTraining] Is Null .." and it isn't Null because of the minutes value.

 

[Gasman]

That might be as the o/p was placing 1/1999 in the field initially?

The problem is that there are some minutes value in the "DateOfTraining" field.
Therefore the update query doesn't update because it has the criteria "IIf([DateOfTraining] Is Null .." and it isn't Null because of the minutes value.

 

[mohamedmatter]

replace your Update To field with:

IIf(Nz([DateOfTraining],0)<#1/1/1999#,#1/1/1999#,[DateOfTraining])

nots
i set date less then or more then to anther grouptraining