Sep 20th, 2000, 12:34 PM
I have a Query that I can open normally in Visual Basic.
I use the command :
Set rst = DB.OpenRecordset("NewSong")
However I want to set a filter on this Query. I already have the "CRITERIA" on the field I want to limit set to ">= [NewDate]" however I don't know how to pass the Date I want "NEWDATE" to be equal to. Can anyone help with this seemingly simple task?
I use the command :
Set rst = DB.OpenRecordset("NewSong")
However I want to set a filter on this Query. I already have the "CRITERIA" on the field I want to limit set to ">= [NewDate]" however I don't know how to pass the Date I want "NEWDATE" to be equal to. Can anyone help with this seemingly simple task?