Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Null

  • Thread starter Thread starter BF
  • Start date Start date
Status
Not open for further replies.
BF

BF

Programmer
Joined
Feb 13, 2000
Messages
10
Location
CA
I've created a query that selects names from a table if the name ID is equel to another field. In those cases where the critera does not match I get a Null which then keeps my query from showing any data at all. What can I put in the &quot;grid&quot; under the &quot;criteria&quot; label that will allow my data to show regardless if I have a Null or not? <p>BF<br><a href=mailto:g43@tc3net.com>g43@tc3net.com</a><br><a href= > </a><br>
 
Sort by date Sort by votes
BF<br>
Use, ie.:<br>
[name ID] = [mytable].[otherfield] or Is Null<br>
<br>
This will show names that match the other field and names that are null<br>
--Jim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question Question
SQL Server '' Value is Null in SPT Query?
Replies
2
Views
289
kray4660
kray4660
nover11
  • Locked
  • Question Question
Access/ Not sure where to insert Null and parameters
Replies
3
Views
315
dhookom
dhookom
hpl2001
  • Locked
  • Question Question
Dealing with a possible Null in a text string
Replies
2
Views
180
hpl2001
hpl2001
bdmoran
  • Locked
  • Question Question
Transfer Spreadsheet Null Values
Replies
10
Views
421
bdmoran
bdmoran
bdmoran
  • Locked
  • Question Question
Null Value in multiple Fields
Replies
5
Views
215
bdmoran
bdmoran

Part and Inventory Search

Sponsor

Back
Top