Trying to find all IDs in a field that start with *

[itm]

Hi,
I am trying to find all IDs in a field that startss with *. I have tryed various forms of using LLeft but it says that the function is undefined. I have names like *CO5468 and I need to find them. I tryed things like Left(tblTemp_Import_File.Accpac__c],1)'*') and Like [*%], but nothing works.
Any ideas would be really appreciate it.
Thank you

[ssanfu]

Do you have a reference set to "Microsoft DAO 3.6 Object Library"? To check, press Control G (the control key and the letter G), then go to Tools/References.


In a query, add the table, then in a column, add:
Expr1: Left(tblTemp_Import_File.Accpac__c],1)
Then in the criteria row, enter "*"

If you still can't get it to work, post the SQL of your query.

[itm]

Thanks for the reply,
I checked I do have it set to "Microsoft DAO 3.6 Object Library" and I am using MS Access 2007
It givess me "Undefind function Left" error
Here is the query as it stands now:
SELECT tblTemp_Import_File.ID, tblTemp_Import_File.Accpac__c, Left([tblTemp_Import_File].[Accpac__c],1) AS Expr1
FROM tblTemp_Import_File LEFT JOIN tblSF_Accounts ON tblTemp_Import_File.Accpac__c = tblSF_Accounts.Accpac__c
WHERE (((tblSF_Accounts.Accpac__c) Is Null) AND ((Left([tblTemp_Import_File].[Accpac__c],1))="*"));

Thank you

[ssanfu]

Everything look correct (to me).
Care to post your dB??? I'll look at it tonight..