Because of a query where I am avoiding duplicates, (Date3: IIf([Last]=[Date1],"",[Last])), I have a date field that is in text format instead of date format. How can I write the query to save it as date format.

Thanks,
Eva

I finally got it to work. I revised the query so that I don't have a null value.