Access 2007 Follow

0
Avatar
Legacy Poster

When I bring up the database connection and connect to my database, without any criteria, it pulls all my information correctly. I only have one field of information and it is locations ie. 22AA01, 22AB01, 22AC01. When I enter criteria in my database "##*A##" the database will return all locations that have an "A" as the fourth character. When I bring it into BarTender I get no results. Does anyone know why?

1 comments

0
Avatar
Shotaro Ito
Moderator
Comment actions Permalink

Use ANSI92 style wildcard (%_[a-z]).

%: match any string
_: match single character
[ABC]:match A or B or C
[0-9]:match 0 to 9(digits)

try query like..
[sql]
Fields | Operator | Criteria
-----------------------------
F1 | Like | [0-9][0-9]_A[0-9][0-9]
[/sql]

It looks you need to follow it when use OLEDB connection to Access DB.
office.microsoft.com/en-us/access-help/comparison-of-microsoft-jet-sql-and-ansi-sql-HP001032250.aspx

Please sign in to leave a comment.