Help Writing an If Then Statement in a Query

[tanyalee123]

I need to write an If Then statement in a query (I think!).

I have a field DateofService that is updated every month from a spreadsheet I import. After some changes made to the data I receive, there are instances where that field is now blank. Unfortunately, that field is a 2nd primary key in one of my tables.

There is a 2nd date in the spreadsheet that I could use to populate that field, so what I would like to say in the update query is that if the DateofService field has data in it then populate it with that date, but if the DatofService field is empty then populate the field with the data from the ActualOtherDate field. I've tried a hundred different ways to do it, but I've never written a statement like that before so I'm coming up short somewhere.

Thank you for any help.


Tanya

[June7]

In the UpdateTo line: Nz([DateofService], [ActualOtherDate])