please help me.

[duroy1234]

i want to express this one to if 3g.lac is null =son.lac please help me with this.

IIF([3G DUMP].LAC IS Null,[SON].LAC,[3G DUMP].LAC) AS LAC

 

[theDBguy]

Hi. You could try it this way too.

Nz([3G DUMP].LAC,SON.LAC) AS LAC

 

[duroy1234]

Hi. You could try it this way too.

Nz([3G DUMP].LAC,SON.LAC) AS LAC

thank you bro.

 

[duroy1234]

Hi. You could try it this way too.

Nz([3G DUMP].LAC,SON.LAC) AS LAC

bro when i used Nz function when i try to connect to excel the query that i created didn't see on the excel what is wrong in my command here is my command.

SELECT Nz([3G DUMP].[RNC ID],SON.RNCID) AS RNCID, Nz([3G DUMP].NodeBID,SON.NodeBID) AS NodeBID, Nz([3G DUMP].[RNC Name],SON.RNCNAME) AS RNCNAME, Nz(SON.NodeBName,[3G_STATUS].NodeBName) AS NodeBName, Nz([3G DUMP].CellID,SON.CellID) AS CellID, Nz([3G DUMP].[Site Tag],SON.[Site Tag]) AS [Site Tag], [SEMI FINAL].CellName, Nz([3G DUMP].LAC,SON.LAC) AS LAC, Nz([3G DUMP].RAC,SON.RAC) AS RAC, Nz([3G DUMP].SAC,SON.SAC) AS SAC, Nz([3G DUMP].UARFCNDownlink,SON.UARFCNDownlink) AS UARFCNDownlink, Nz([3G DUMP].UARFCNUplink,SON.UARFCNUplink) AS UARFCNUplink, Nz([3G DUMP].PSC,SON.PSC) AS PSC, DataBase.LATITUDE, DataBase.LONGITUDE, DataBase.Azimuth, DataBase.Outdoor, IIf(DataBase.Sectorization="MACRO","Sectorize","OMNI") AS Sectorization, DataBase.AntHeight AS AntHeight, DataBase.MechTilt, DataBase.ElecTilt, DataBase.[Final Antenna Option] AS AntType, DataBase.[SUB TYPE] AS SiteType, DataBase.[TECH BAND] AS [Frequency Band], IIf(Outdoor="YES","0","1") AS INDOORFLAG, DataBase.AREA, DataBase.PROVINCE, DataBase.MUNICIPALITY, DataBase.[DATA INPUT] AS DATA, DataBase.STATUS, [3G DUMP].State, DataBase.[Final Antenna Brand], [Frequency Band] & "_" & [AntType] & "_" & [Final Antenna Brand] AS CONCATENATE
FROM ((([SEMI FINAL] LEFT JOIN SON ON [SEMI FINAL].CellName = SON.CellName) LEFT JOIN [3G DUMP] ON [SEMI FINAL].CellName = [3G DUMP].CellName) LEFT JOIN 3G_STATUS ON [SEMI FINAL].CellName = [3G_STATUS].CellName) LEFT JOIN [DataBase] ON [SEMI FINAL].CellName = DataBase.CellName
WHERE ((([SEMI FINAL].CellName) Is Not Null));