I am trying to execute SQL statement within Access 2010 with LIKE parameters but its not returning anything.
When use = operator it works fine but returs exact match.
And I want to return rows where CompanyName may have a part of a string,
SELECT [tblSaturdayReport].[Company No], [tblSaturdayReport].[Job Order No] FROM tblSaturdayReport
WHERE [tblSaturdayReport].[Company Name] = 'Accenture';
SELECT [tblSaturdayReport].[Company No], [tblSaturdayReport].[Job Order No] FROM tblSaturdayReport
WHERE [tblSaturdayReport].[Company Name] LIKE '%Acce%';
So my first query works but my second query doesn't return anything at all.
Please help as to what am I missing.
Thanks a lot in advance.
So I tried this instead of % but this doesn't return anything at all as well.
I mean it doesn't return any error but it doesn't return anything at all.
Basically I trying to return any company name that contains "Acc" .
Ohh my bad.... yes I typed
tblSaturdayReport.[Company Name]= "Acc"
because I want company name with "Acc" anywhere in between also.
So any number of characters at begibibg and any number of characters in the end as well.
I tried single cotes and double coyes both ' and "
Ohh my bad.... yes I typed
tblSaturdayReport.[Company Name]= "Acc"
because I want company name with "Acc" anywhere in between also.
So any number of characters at begining and any number of characters in the end as well.
I tried single cotes and double cotes both ' and "