Update Query IF

[JordanR]

I'm importing log files that don't have a date field. I was thinking the easiest way to fix this is to run an import, then do an update query to add the date (today's date)to any records that have a null value for that element, but I have no idea how to do the update.
Importing isn't an issue, but if someone can give me a clue on how to do that, I'd appreciate it.

 

[Dennisk]

here is an exapmle

UPDATE TblApplication SET TblApplication.DateOfApplication = Date()
WHERE (((TblApplication.DateOfApplication) Is Null));

 

[JordanR]

THAT was way too simple. Boy did I overthink that one.
Thanks.