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!

dataview rowfilter 1

Status
Not open for further replies.
zatch

zatch

MIS
Joined
Oct 11, 2001
Messages
75
Location
US
This seems like it should be easy, but I just can't figure this one out. In the example below, I have been successful in filtering out rows where [call_due] = (today). What I really want to do, however, is filter where [call_due] is null. I'm sure the answer is simple, and I hope someone can help.

Thanks.

"Username = '" + strUsername + "' and call_due = '" + Date.Today & "'"
 
Sort by date Sort by votes
"Username = '" + strUsername + "' and call_due IS NULL"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Auguy
  • Locked
  • Question Question
Get Dataview Name From Array of Dataviews
Replies
4
Views
182
jebenson
jebenson
Auguy
  • Locked
  • Question Question
Using Absolute Value in RowFilter
Replies
3
Views
251
RiverGuy
RiverGuy
Andrzejek
  • Locked
  • Question Question
Read data from DataView
Replies
2
Views
125
Andrzejek
Andrzejek
NoCoolHandle
  • Locked
  • Question Question
Dataview not saving update to Dataset.
Replies
1
Views
105
NoCoolHandle
NoCoolHandle
SBendBuckeye
  • Locked
  • Question Question
Using Compound conditional in a DataView RowFilter
Replies
1
Views
78
Mastakilla
Mastakilla

Part and Inventory Search

Sponsor

Back
Top