>Does anyone know how I can implement IIF statements in an SQL. I am running a SQL select statement that looks for the patient id but the problem arises when the patient has two different visit dates to the doctor. but I only need the latest date.

Yes, if you only plan to query against local tables.
No, if you want to talk to a SQL server backend.