Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

criteria: is not null doesn't work on an expression

Posted on 2004-09-01
2
Medium Priority
?
593 Views
Last Modified: 2010-05-18
the expression:

HasValue: IIf(Not IsNull([column_a]) And Not IsNull([column_b]) And Not IsNull([column_c]),"T","")

cannot accept the criteria: is not null

how can i limit my query to do this
0
Comment
Question by:manoj91
2 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 1400 total points
ID: 11959495
Whereabouts are you trying to use the criteria? What version of Access are you using btw?

The above expression will never be null - it will either equal "T" or "".Try:
<>""
0
 

Author Comment

by:manoj91
ID: 11959511
access 2002
Field: HasValue: IIf(Not IsNull([FName_Council]) And Not IsNull([LName_Council]) And Not IsNull([CompName_Council]),"T",null)
Criteria: Is Not Null

that works, tks.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question