On Fri, 17 Sep 2004 15:11:37 +0000 (UTC), Alan Carpenter wrote:
fredg <fg******@example.invalid> wrote in
news:ds*****************************@40tude.net:
On 16 Sep 2004 06:27:22 -0700, Marcel wrote:
Hello,
I'm trying te maken an update SQL statement. I Use the function
Between And.
The problem is that the values I use by between are alphanumeric. Now
the function between doesn't work. Can anybode tell me how I can solve
this problem.
Thanks,
Marcel
Use >= and <=
Where [FieldName] >="asd123" and <= "zxy987"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Or, if your VBA works like my VBA (Access97):
Where [FieldName] >="asd123" and [FieldName] <= "zxy987"
I've always disliked having to add that second Reference. <g>
Cheers,
Alan Carpenter
Aha! You got that goof.
Thanks for correcting it.
Yes, it is a shame we have to enter that second reference, but then we
all know computers aren't smart enough to make that leap in logic for
us. :-)
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.