Comments
No comments.
0, core.name, header.name) as name2 In the Access query builder, you can do the same thing but the syntax is slightly different. Instead of entering a field name, type: name2: IIf(Len([core04pc.name])>0,[core04pc.name],[ddheader.name]) In 'SQL View,' you will see: IIf(Len([core04pc.name])>0,[core04pc.name],[ddheader.name]) AS name2 ...same as mysql or SAS but: - LENGTH() is LEN() - IF() is IIF() - Square brackets are required around the field names or they get interpreted as character strings, I believe.">
Please contact us at [email protected]. We are sorry for the inconvenience.
|