Re: using the .filter command

Tech-Archive recommends: Fix windows errors by optimizing your registry

Chris Anderson [MVP-VB] wrote:
Well, I think it *should* be safe to assume that EntryDate is just
that.... and needs to be enclosed as such. Even if it isn't a date and
it's a string (tisk, tisk), it still needs delimiters on it.
flt_txt = "EmployeeNumber = " & Text2.Text & _
"AND EntryDate < #" & DateValue(Text4.Text) & "#"

You're probably correct. I just wanted the OP to have a chance to figure it
out on his own after reading the docs.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.