filter not working

[lilbit27]

Dim linker
Dim strSQL As String
linker = StobMainFrame.Value
Select Case linker

strSQL = "TStobDaily.Category In('61','73') AND TStobDaily.DateIn

#5/31/2007# AND PendDte Is Null AND Tstobdaily.LogInID=fOSUserName()"

End select
End Sub

The "DateIn" is still bring back dates less than 5/31/2007. Any
suggestions?

 

[Jeff Boyce]

Take a look at what is actually stored in your DateIn field in the table.
Is it ONLY date values, or date/time values?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[lilbit27]

Take a look at what is actually stored in your DateIn field in the table.
Is it ONLY date values, or date/time values?

--
Regards

Jeff Boycewww.InformationFutures.net

Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/









- Show quoted text -

only dates

 

[Jeff Boyce]

Were this mine, I'd copy the SQL statement and paste it into a new, empty
query (in SQL View), then try to convert the view to Design View, to help me
see how the criteria were being applied.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/