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

select no record

Status
Not open for further replies.
3dthies

3dthies

Programmer
Mar 12, 2003
77
DE
I have a database something like that:

Date One Two Three
2003/09/01 A B X
2003/09/02 S D D
2003/09/03 S S
2003/09/04 W W W
...
...
...
...

I want to display just the fields (Three) except the entry with no record.
 
Sort by date Sort by votes
RECORD SELECTION FORMULA

IsNotNull {Table.THREE} AND {Table.THREE} > ""
 
Upvote 0 Downvote
Slight change:

not isnull({table.three}) and
trim({table.three}) <> &quot;&quot;

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
Select Expert
Replies
2
Views
195
john432
john432
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
436
mmck1964
mmck1964
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
422
Cpreston
Cpreston
inkbird01
  • Locked
  • Question
Filters &gt; Record Selection for dates between
Replies
4
Views
320
pmax9999
pmax9999
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
287
Cpreston
Cpreston

Part and Inventory Search

Sponsor

Back
Top