Search results

I would like to know the difference between these two concepts. Would anyone care to explain it to me?

I don't understand these two concepts. Would anyone care to explain it to me?

SELECT [asset class] , iif(ct2.[asset class]='3050', 'yes', 'Nope!') IIF_Example FROM CONVERSION_TABLE_2 AS ct2; The above isn't working because of my attempt to name the column. I want to call the column "IIF_Example." Why doesn't it work? Thanks

SELECT Conversion.[Asset Class], iif([asset class]<4000, "1", "2") FROM Conversion;

SELECT [FA Ctr], [SAP Co], [SAP Ctr], [GL Co], Format (([SAP Co],"0000") AS NewField), (([cst ctr], "0000000000") as costcenterappended) INTO [Interim Table] FROM Asset_Map;

Think my syntax is wrong here, but not sure where. I would appreciate any help! Thanks! SELECT a.[FA Ctr], a.[SAP Co], a.[SAP Ctr], a.[GL Co], IIf([Len([SAP CO])] ="3",""0"' & [a].[SAP CO]", IIf([Len([SAP CO])]="2",""'00"' & [a].[SAP CO]"), IIf([Len([SAP CO])]="1",""'00"' & [a].[SAP CO]"...