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!

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

Need help with a view filter

Status
Not open for further replies.

Proteus7

IS-IT--Management
Feb 26, 2002
75
US
Hi,

I have a view that I use to populate a grid. The problem is is that I need only those records that have a date in this date field to show. The view is the data control for this grid. So what I would like to be able to do is to use the views filter tab and say something like

invetory.removed = " / / "

so that all of thoose records with no date entered into that date field will be filltered out of the view.
Can you do this in the view?
IF so how?

thanks,
Larry
 
sorry,

I thought it might help if you know what error I keep reciveing when I do this.

Operator/operand type mismatch
 
thanks ramani,

That was the answer I knew that it was something simmple. I had tried using {} but I was trying to test it with a date in it. That kept kicking out that error. After steping back and walking away, I took your advice and just tried that simple little thing and it worked.

Larry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top