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.">Knowledgebase - - Sorry, there was an error processing record: -

Please contact us at [email protected]. We are sorry for the inconvenience.

Knowledgebase

Documents, videos, websites and more.

Access: Calculated Fields

- Sorry, there was an error processing record: -

Please contact us at [email protected]. We are sorry for the inconvenience.

Brief description or abstract:
The Irvine Access Database has a query called "Master Data" where I combined the data for all variables. The Master Data has missing Name for 4 Eins, because Name comes from my core file, but Eins are pulled from the MasterEins file. So, basically there are 4 eins that are in the Header file or the orgPurpose or the RevExp file, but that are NOT in the Core file. In sql, you want to write something like this: IF( LENGTH( core.name) > 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.
Posting type(s):
Links & Files
URL:
Regions & Topics
Geographic regions: United States
Topic(s):
Subtopic(s):
Number of "Likes":0
Number of Views:
Posting Details
Publication date: 0000-00-00
Tags
Tags:
Added 2006-09-14 by tpollak, Modified 2011-09-27 by kuttkeUI

Comments

No comments.