access - trying to set criteria to equal to "v" but not "V"

  • Thread starter Thread starter Gabriele
  • Start date Start date
G

Gabriele

i am trying to select records with lower case "v" in a particular field but
is also returns capital "V"
 
Take a look at the strComp( ) function.

Field: strComp([FieldName], "v", 0)
Criteria: 0

If the letter "v" you are looking for is a substring in the field, like
"abcv123" then this will not work.

If this is the case, I'd write a little function that I pass the field name
and the character to, and have the function do a character by character
comparison.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
This is one way --
Expr2: Asc(Mid([YourField],InStr([YourField],"G"),1))
with criteria 86 as that is the ASCII code for 'V'.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent Access 2007 from starting setup 2
Access 2003 - Joining number and text data 3
Combining Columns - disregard previous post - sent before I was fi 5
ASUS P8Z77-V Intel Z77 Express LGA 1155 0
ASUS Maximus V Extreme 0
Prevent cursor/focus from moving 2
Find missing PageType 2
The data on the Clipboard is damaged, so Microsoft Office Access can't paste it. 0

Back
Top