I have the following formula in Excel and I am trying to transfer the same formula into an expression builder in Access 2007. Does anyone know what the expression should look like in Access?
=IF(LEFT(VATs!H2,3)="L7R",VATs!E2&VATs!F2,IF(VATs! B2="",TRIM(VATs!E2),IF(VATs!B2<>"",TRIM(VATs!B2)," Not Rent")))