iF THEN VBA STATMENT

[GCLIFTON]

Just changed it to "" and it created a column EXPR1009

[pbaldy]

Like I said:

SELECT Tracker.Combine, Tracker.[Floor Plan], Tracker.Type, Tracker.Scope, IIf([Tracker].[3 Windows]="-1",[Tracker_Budget_Upload_].[3# Windows],0) AS Window, IIf([Tracker].[1 Demo]="-1",[Tracker_Budget_Upload_].[1# Demo],0) AS Demo, IIf([Tracker].[4 Mep Rough]="-1",[Tracker_Budget_Upload_].[4# Mep Rough],0) AS [MEP Rough], IIf([Tracker].[6 Bathtub]="-1",[Tracker_Budget_Upload_].[6# Bathtub],0) AS Bathtub, CDbl(Nz([Demo],0))+CDbl(Nz([Window],0))+CDbl(Nz([MEP Rough],0)) AS Total1, *
FROM Tracker INNER JOIN Tracker_Budget_Upload_ ON Tracker.Combine = Tracker_Budget_Upload_.Combine;