| Search query using MS Access [message #548228] |
Tue, 20 March 2012 22:27  |
reym21
Messages: 241
Registered: February 2010
Location: Philippines
|
Senior Member |
|
|
Sirs,
Good day!
Can you please help me out why I can't filter my needed query using MS Access... I need to query all Country that belongs to
"FINLAND" but it includes the "CHINA" record always. The same scenario where I searched for "JAPAN" and "INDONESIA", the record for "CHINA" still displayed/extracted. I presumed that every Country that I searched with letters containing I, A & N, the said query executes it. Here's the said query:
SELECT Qry_VEC_Tabular_Formatted.vec_no, Qry_VEC_Tabular_Formatted.embassy_name, Qry_VEC_Tabular_Formatted.Name, Qry_VEC_Tabular_Formatted.designation, Qry_VEC_Tabular_Formatted.Dependents, Qry_VEC_Tabular_Formatted.dfa_id_no, Qry_VEC_Tabular_Formatted.country, Qry_VEC_Tabular_Formatted.[issuance date], Qry_VEC_Tabular_Formatted.[validity date], Qry_VEC_Tabular_Formatted.remarks, Qry_VEC_Tabular_Formatted.Status
FROM Qry_VEC_Tabular_Formatted
WHERE (((UCase([Qry_VEC_Tabular_Valid].[country])) Like [Forms]![Frm_VEC_Tabular]![UptxtString]));
Please also refer the screenshot I uploaded.
Thanks in advance.
-
Attachment: finland.jpg
(Size: 150.03KB, Downloaded 1634 times)
|
|
|
|
| Re: Search query using MS Access [message #548238 is a reply to message #548228] |
Wed, 21 March 2012 00:29  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
This question bears no real connection with Oracle database.
Please find a more appropriate forum.
The topic is locked.
If I'm wrong, please, PM me (or report this message to a moderator, explain why you think it should be unlocked and it might be done).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
