Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Queries
Combining Fields in a Query into Two Fields
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="John W. Vinson, post: 9379026"] An IIF statement has THREE arguments - you're giving it two. The first argument is an expression which is True or False; the second is the value to return if it's True; the third is returned if it's False. You specify that the first UNION query SELECT should return "Good" if Field1 is -1 - but what should it be if Field1 is (say) +3? It's similar for the others. What do you want to see if the fields have SOME OTHER value than the one in the IIF? John W. Vinson [MVP] [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Queries
Combining Fields in a Query into Two Fields
Top
