Null Expressions

30 pts.
Tags:
NULL
Null Expressions
I am sure this is simple, I just need to know what the expressions is if you have fields in lets say a report that are : some empty and some with information...such as Telephone Field. I want to show only those "telephone" that are actually in the field. Example John Doe 555-555-5555 430 Cow Street anywhere, usa Jane Doe 560 Horse Street everywhere, usa I realize it is a null expression, but I am not getting something right.
ASKED: April 7, 2009  6:17 PM
UPDATED: April 12, 2009  7:50 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you working with SQL, a programming language, or a reporting application?

Sorry, I am working in ACCESS, On a report. I will be one of those people who taught myself how to use ACCESS. Not exactly a newbie, but close. I know how to many things, but haven’t a clue how I did it most of the time

—————————

This <a href=”http://support.microsoft.com/kb/q208529/”>link</a> is a good reference for Access report filtering.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Technochic
    What application?
    57,010 pointsBadges:
    report
  • Karenfae
    ACCESS: In a Report (hope I answered that correctly)
    30 pointsBadges:
    report
  • SbElectric
    I am assuming the report is based on a query. Then set the query to display if Telephone is "not Null". Then you should get only the records that have Telephone numbers.. The Report based on this query should yield the desired result. The easiest way to set the query will be in Design mode -- select the fields you want in the report. For Telephone -- on the criteria use " Is not Null". Hope this helps. If not please provide more details.
    2,540 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following