Hello! I have a query in which I am joining many autonumber fields. I converted all autonumbers to long integer using CLng. e.g. AccountingDivisionID: CLng([BudgetLevel07].[AccountingDivisionID])
Here is the SQL. The query was working fine, but now suddenly I am getting this mismatch error.
Thoughts?
SELECT [2000-000 - PROJECT].[2000-000-030 - PROJECT NAME], [OPTIONS - DEVELOPER].DEVELOPER, CLng([BudgetLevel07].[2000-000-010 - ID]) AS [2000-000-010 - ID], CLng([2700-000 - BUDGETS].[BudgetID]) AS BudgetID, BudgetLevel07.BudgetName, BudgetLevel07.AnticipatedChangeinLLC_MV_PerAcre, BudgetLevel07.ConstructionDurationMonths, BudgetLevel07.ConstructionInterestRate, BudgetLevel07.SellOutMonths, BudgetLevel07.DiscountToHomeCompany, BudgetLevel07.BudgetLots, BudgetLevel07.BudgetStreetLength, BudgetLevel07.BudgetAcres, BudgetLevel07.BudgetAverageLotWidth, BudgetLevel07.BudgetCalcType, BudgetLevel07.IsTrailingCost, CLng([BudgetLevel07].[BudgetLineItemID]) AS BudgetLineItemID, CLng([BudgetLevel07].[AccountingCodeID]) AS AccountingCodeID, BudgetLevel07.OriginalEstimateValue, BudgetLevel07.AdjustmentAmount, BudgetLevel07.LinealFeet, BudgetLevel07.Notes, CLng([BudgetLevel07].[BudgetCalcTypeID]) AS BudgetCalcTypeID, CLng([BudgetLevel07].[AccountingDivisionID]) AS AccountingDivisionID, BudgetLevel07.AccountingCode, BudgetLevel07.AccountingCodeDescription, BudgetLevel07.BudInflowOutflow, BudgetLevel07.BudIsContractItem, BudgetLevel07.BudIncludeInInterestCalc, BudgetLevel07.BudDevelopmentDirectCost, BudgetLevel07.BudDevelopmentDirectAndOffsiteCost, BudgetLevel07.BudDevelopmentCostNoInt, BudgetLevel07.AccountingDivisionDescription, BudgetLevel07.OEI1, BudgetLevel07.ContractCostExcContingency, BudgetLevel07.OEI2, BudgetLevel07.OEI3, BudgetLevel07.ContractCost, BudgetLevel07.OEI4, BudgetLevel07.OEI5, BudgetLevel07.DevelopmentDirectAndOffsiteCost, BudgetLevel07.DevelopmentDirectCost, BudgetLevel07.DevelopmentCostNoInt, BudgetLevel07.OEI6, BudgetLevel07.OriginalTotalCost, BudgetLevel08A.OriginalTotalCostEntireProject, BudgetLevel07.OriginalCostPerLot, BudgetLevel07.OriginalCostPerAcre, BudgetLevel07.OriginalCostPerFtOfStreet, [OriginalTotalCost]/[OriginalTotalCostEntireProject] AS OriginalPercentTotalContract, BudgetLevel07.AdjustedTotalCost, BudgetLevel08B.AdjustedTotalCostEntireProject, BudgetLevel07.AdjustedCostPerLot, BudgetLevel07.AdjustedCostPerAcre, BudgetLevel07.AdjustedCostPerFtOfStreet, [AdjustedTotalCost]/[AdjustedTotalCostEntireProject] AS AdjustedPercentTotalContract
FROM ([OPTIONS - DEVELOPER] INNER JOIN (((BudgetLevel07 INNER JOIN BudgetLevel08A ON BudgetLevel07.BudgetID = BudgetLevel08A.BudgetID) INNER JOIN BudgetLevel08B ON BudgetLevel07.BudgetID = BudgetLevel08B.BudgetID) INNER JOIN [2000-000 - PROJECT] ON BudgetLevel07.[2000-000-010 - ID] = [2000-000 - PROJECT].[2000-000-010 - ID]) ON [OPTIONS - DEVELOPER].[DEVELOPER ID] = [2000-000 - PROJECT].[2000-000-060 - DEVELOPER]) INNER JOIN [2700-000 - BUDGETS] ON BudgetLevel07.BudgetID = [2700-000 - BUDGETS].BudgetID;