473,414 Members | 1,757 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

how to make a query doesn't show the records (null) ?

i need a query that doesn't show records that has a certain fields (null)
May 2 '16 #1

✓ answered by jforbes

It's pretty much the same thing with the Not keyword inserted into it. That is also detailed in the link: Examples of query criteria
Is Not Null
Returns records where the value is not missing in the field.

3 721
jforbes
1,107 Expert 1GB
You can use the Is Null criteria to perform the desired function. It's pretty straight forward. This is from Mirosoft: Examples of query criteria

Is Null
This criterion can be applied to any type of field to show records where the field value is null.
May 2 '16 #2
i want it don't show the record if it is null
May 2 '16 #3
jforbes
1,107 Expert 1GB
It's pretty much the same thing with the Not keyword inserted into it. That is also detailed in the link: Examples of query criteria
Is Not Null
Returns records where the value is not missing in the field.
May 2 '16 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Daniel | last post by:
how to make sure a xsl document has valid xsl syntax? i tried loading it into an xml document but that doesnt show syntax errors inside attributes such as "foo/bar" vs "bar\foo"
8
by: pmud | last post by:
Hi, I am using a compare validator in asp.net application(c# code). This Custom validator is used for comparing a value enterd by the user against the primary key in the SQL database. IF the...
1
by: NewUser | last post by:
I try this: A first "group" query (sorry if this isn't the right name) count the records from a table with a criteria (field1="A") and return counter1=10 records. A second "group" query count the...
1
by: gus1339 | last post by:
Does anyone know how to do this? a query to show only rows where joined fields from both table are NOT equal Thanks!
4
by: jasone | last post by:
Hi, I am about to create a system which will alert the user of any orders which need to be processed a day in advance: is there a simple query to show all records in a table 1 day befor the...
11
by: bikefixxer | last post by:
I'm a beginner with Access and am using the 2007 version on XP. I've created a database that keeps track of employee hours where I work. Everything has worked fine until we recently hired someone...
1
by: Steve | last post by:
I have to tables Table1 IMS_ID IMS_Name IMS_Descript Table2 P_IMS_ID P_IMS_Name P_IMS_Descript
3
by: kkshansid | last post by:
<?php session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html...
1
by: sumreen hassan | last post by:
how to show all null fields of query during run time? for example if one column of record is null all record is skiped please help me about this problem
4
by: jase7678 | last post by:
Hello, I'm confused with my latest issue in Access 2013 because at one point in time it's worked exactly as intended. I'm putting together a pretty large database application so finish one piece...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.