Yes I have used the very limited Help feature on Access, I have search on countless forum pages for examples to go by. The problem I have is none of the example I have found are doing exactly what I am looking for which is evaluating one field and based on that field populate with another field. So I have searched hi and low as well as experimented and no luck.

And how would I create a select case. Like I said I am pretty novice to this and not even sure if I wrote this function right. Thanks for the help.

Hi Everyone,
I am in a bit of a pickle and need some expert advice. I have a db in access. I am trying to create a query with fields from the tables. In my query I need to take the value of one field and depending on what the value is pull a date from other fields. I have tried a IIF and it errors. Tried to write an if-then-else function ( which I doubt I did right since I have never done one) and I get an undefined expression error.
...