The decimal field's precision is too small--when making query by access

  • Thread starter Thread starter murat
  • Start date Start date
M

murat

HI;
I HAVE MYSQL DATABASE (4.0.20). I LINK MY TABLES TO AN
ACCESS 2002 FORM.
MY AIM IS TO QUERY TABLES BY THESE FORMS.
I HAVE INSTALLED MICROSOFT JET 4.0 SP 8 PACKAGE.
WHEN I QUERY WITH MATCH "WHOLE FIELD" (FIND) OR "START OF
FIELD" THERE IS NO PROBLEM.
HOWEVER WHEN I QUERY WITH MATCH
"ANY PART OF FIELD" THERE IS NO ANSWER OR THE ANSWER IS
SHOWN SO LATE(CAN SHOW ONLY FIRST 300 ANSWER). FOR OTHER
DATA
THE POP UP SHOWS "The decimal field's precision is too
small"

EXAMPLE
ADRESS ='ISTANBUL TECHNICAL UNIVERSITY'. I WANT TO FIND
FROM ADRESS LIST.

1ST QUERY => WHOLE FIELD =>FIND='ISTANBUL TECHNICAL
UNIVERSITY' => OK
2ND QUERY => START OF FIELD => FIND='ISTANBUL' => OK
3RD QUERY => ANY PART OF FILED => FIND='ISTANBUL' =>
PROBLEM

I NEED YOUR ADVICES
THANKS IN ADVANCE.

MURAT SEZER
 
Murat

Please post in mixed case -- all CAPS is difficult to read, and some
consider it equivalent to "shouting".

When you create a query in Access, you can specify a partial match as a
criterion by using wild card characters. In the criterion "cell" of the
query design grid, use the following, based on your three examples:

"Istanbul Technical University"

Like Istanbul*

Like *Istanbul*
 
Back
Top