Problem with mid function in Access 2002

[giecie]

When I try to use the mid function in my Access 2002 in a query I got streange behavings;

e.g:

table1: ID=1 & test=ABCDEFG
query1: mid([test],2,2)

should give me BC
but gives BCDEFG

Like it doesn't take care of the last 2 in the mid function.

Is trere any explannation for this?

 

[Chopstik]

That is odd behavior. I am unable to duplicate the problem. Perhaps an error with the installation or with the software itself?

--------------------------------------------------------------------------------------------------------------------------
Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
--Douglas Adams