I am hoping the right number and placement of quotation marks will make this work. I have this in a text field >100000. I want to use that text field as criteria in a query to look up a currency field. I get a "Type mismatch in expression" dialogue. Here's the sql:
SELECT A5.*, InvestorClient.ClientName, A5.BigTableActives.Zip, A5.LP
FROM A5, InvestorClient
WHERE (((InvestorClient.ClientName)="Bob") AND ((A5.BigTableActives.Zip)=[InvestorClient]![Zip]) AND
((A5.LP)=[InvestorClient]![ListPr]));
It's the last line giving me fits. Thanks for any help!
SELECT A5.*, InvestorClient.ClientName, A5.BigTableActives.Zip, A5.LP
FROM A5, InvestorClient
WHERE (((InvestorClient.ClientName)="Bob") AND ((A5.BigTableActives.Zip)=[InvestorClient]![Zip]) AND
((A5.LP)=[InvestorClient]![ListPr]));
It's the last line giving me fits. Thanks for any help!