Type Mismatch

[Guest]

I need help building a link criteria....here is what I have:

Dim stLinkCriteria AS String

stLinkCriteria = "[VehicleNumber]='" & Me![VehicleNumber] AND_
"[DispositionDate]=<" & Me![txtStartDate] OR "[DispositionDate]=<"_
& Me![txtEndDate]'


txtStartDate and txtEndDate are in Short Date format, chosen from a popup
calendar.

What I am trying to do is search through the tblDispositions and find all
the dispositions that match [VehicleNumber] between [txtStartDate] and
[txtEndDate].

Thanks in advance....

 

[Brendan Reynolds]

Your "AND" and "OR" are outside the quotes. You also appear to have a single
quote in front of VehicleNumber but no single quote after it. And Jet will
not accept =< or => in queries, it needs <= and >=. And dates should be in
US format and delimited with '#' characters. Try ...

stLinkCriteria = "VehicleNumber = '" & Me!VehicleNumber & "' And " & _
"DispositionDate <= #" & Format$(Me!txtStartDate, "mm/dd/yyyy") & "# OR
" & _
"DispositionDate <= #" & Format$(Me!txtEndDate, "mm/dd/yyyy") & "#"

Note that while the above should (baring possible typos or lapses of memory
on my part) solve the syntactical problems, I think there may be a problem
with the logic. If you're looking for dates between the two dates specified,
inclusive, the logic would be >= start date and <= end date.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.