Update Date/Time Field

[Guest]

I am trying to run an update query where if the Date/Time field is blank, I
want it to enter today's date. Here's what I have:
UPDATE Royalties SET Royalties.DatePaid = Now()
WHERE (((Royalties.DatePaid)="IsNull"));

I'm getting a data type mismatch, so I'm assuming that it has something to
do with the "DatePaid" field being a date/time field. I'm self-taught in
Access so I'm not too knowledgeable about what I could be missing to make
this work. Could someone help me?

Thank you so much!!

 

[Jeff Boyce]

WHERE IsNull([Royalties].[DatePaid]) = True

You tried to compare a date/time field with the literal string "IsNull"...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Great, Got it!! Thanks for your help!

WHERE IsNull([Royalties].[DatePaid]) = True

You tried to compare a date/time field with the literal string "IsNull"...

Regards

Jeff Boyce
Microsoft Office/Access MVP

I am trying to run an update query where if the Date/Time field is blank, I
want it to enter today's date. Here's what I have:
UPDATE Royalties SET Royalties.DatePaid = Now()
WHERE (((Royalties.DatePaid)="IsNull"));

I'm getting a data type mismatch, so I'm assuming that it has something to
do with the "DatePaid" field being a date/time field. I'm self-taught in
Access so I'm not too knowledgeable about what I could be missing to make
this work. Could someone help me?

Thank you so much!!