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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Null

Status
Not open for further replies.
BF

BF

Programmer
Feb 13, 2000
10
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
SQL Server '' Value is Null in SPT Query?
Replies
2
Views
54
kray4660
kray4660
nover11
  • Locked
  • Question
Access/ Not sure where to insert Null and parameters
Replies
3
Views
72
dhookom
dhookom
hpl2001
  • Locked
  • Question
Dealing with a possible Null in a text string
Replies
2
Views
42
hpl2001
hpl2001
bdmoran
  • Locked
  • Question
Transfer Spreadsheet Null Values
Replies
10
Views
98
bdmoran
bdmoran
bdmoran
  • Locked
  • Question
Null Value in multiple Fields
Replies
5
Views
53
bdmoran
bdmoran

Part and Inventory Search

Sponsor

Back
Top