data Type Mismatch for DateAdd

[b_karv]

Hi all

Got a little problem. I am running an update query for a table called tbl_PrintReminders

I have a PrintDate field in that table with a type of Date/Time.

What I want to do is Add 3 months to all the Dates within the tbl_PrintReminders.

So I got a query running and within the 'Update To: ' Column for PrintDate I have the following: DateAdd("m",3,"PrintDate")

When I run it i get a "datatype mismatch error in Criteria expression".

ANyhelp will be grate full

 

[Jon K]

Remove the quotes from PrintDate and put it in square brackets i.e.
[PrintDate]
.

 

[b_karv]

Thanks for that...I just realised my mistake 5 mins ago....................GOD I HATE ACCESS

haha

thanks mate