Query Question!

[Bob]

Can I make a query not show that line if the 2nd column is empty. The query
has 3 columns but don't want to show it if the 2nd column is empty


Thanks in advance.........Bob Vance

 

[Ken Snell \(MVP\)]

Something like this?

SELECT * FROM TableName
WHERE TableName.NameOfField2 Is Not Null;

 

[Bob]

Ken where do I put this script? Thanx Bob

Something like this?

SELECT * FROM TableName
WHERE TableName.NameOfField2 Is Not Null;

 

[Larry Linson]

Ken where do I put this script? Thanx Bob

That is the Query. You can paste it into the SQL Window of a Query, if you
wish, in the Query Builder. Be sure to use the exact names you've used in
defining the Fields in your Tables.

Larry Linson
Microsoft Access MVP

 

[Bob]

Brilliant Got it, Can I do a sort on Column1 (OwnerName) Thanx..Bob
SELECT *
FROM tblHorseOwnerPercentage
WHERE tblHorseOwnerPercentage.HorseName Is Not Null;

 

[Douglas J. Steele]

SELECT *
FROM tblHorseOwnerPercentage
WHERE tblHorseOwnerPercentage.HorseName Is Not Null
ORDER BY OwnerName

or

SELECT *
FROM tblHorseOwnerPercentage
WHERE tblHorseOwnerPercentage.HorseName Is Not Null
ORDER BY 1

 

[Bob]

Oops, what is wrong with this added Unique Values to yes
SELECT *
FROM tblHorseOwnerPercentage
WHERE tblHorseOwnerPercentage.HorseName Is Not Null;
WHERE (((tblHorseOwnerPercentage.HorseName) Is Not Null));

 

[Bob]

HorseName is still showing in drop down box when it is empty....Thanx Bob

 

[Ken Snell \(MVP\)]

Try this (catches both Null and empty string values):

SELECT *
FROM tblHorseOwnerPercentage
WHERE Len(tblHorseOwnerPercentage.HorseName & "") > 0l
ORDER BY OwnerName;

 

[Bob]

Brilliant Thanks....Bob

Try this (catches both Null and empty string values):

SELECT *
FROM tblHorseOwnerPercentage
WHERE Len(tblHorseOwnerPercentage.HorseName & "") > 0l
ORDER BY OwnerName;

 

[Ken Snell \(MVP\)]

Typo, I see:

SELECT *
FROM tblHorseOwnerPercentage
WHERE Len(tblHorseOwnerPercentage.HorseName & "") > 0
ORDER BY OwnerName;

But, I assume you corrected the typo because you made it work! ;-)

 

[Bob]

Yes thought 01 was a bit strange

Typo, I see:

SELECT *
FROM tblHorseOwnerPercentage
WHERE Len(tblHorseOwnerPercentage.HorseName & "") > 0
ORDER BY OwnerName;

But, I assume you corrected the typo because you made it work! ;-)

 

[Bob]

Ken what do I use for conditional Format to make a cell red when it is
(Blank Empty) thanx bob