Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

MS Access question

Old 04-22-04, 08:43 PM
  #1  
Senior Member
Thread Starter
 
Join Date: Sep 2002
Location: Alexandria, Va/Milpitas, Ca
Posts: 858
MS Access question

Hello,

To all Access users...

When I run a query,
How do I display records that don't have data in a particular field.

For each record, I assign a number, 1-8.
Some records do not have a number.
Is there a way that I can query, and show those records that do not have a number in that field?

Does that make sense?

TIA!!
Barney1234 is offline  
Old 04-22-04, 08:52 PM
  #2  
X
Administrator
 
X's Avatar
 
Join Date: Oct 1987
Location: AA-
Posts: 10,684
Put "is null" as the Criteria in that field.
X is offline  
Old 04-22-04, 08:56 PM
  #3  
Senior Member
Thread Starter
 
Join Date: Sep 2002
Location: Alexandria, Va/Milpitas, Ca
Posts: 858
Very cool, thanks man!
Barney1234 is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.