Thanks for the correction, but that hasn't helped. I'm still getting the
errors. Any more ideas?

"JL" wrote:

Hi Melinda,

You put the "-3" in the wrong bracket.

Should be,
SELECT Left([Contract],Len([Contract])-3) AS JobCode FROM lnkBILLEDBLIINVOICE;

Hope this will help.


"Melinda" wrote:

Hello,
I am trying to query out all but the last 3 characters of my contract name.
Here's the SQL I'm using:

SELECT Left([Contract],Len([Contract]-3)) AS JobCode
FROM lnkBILLEDBLIINVOICE;

I can't see anything wrong with it, but all I get is #Error in all of my
fields. Any ideas on what I'm missing? I'm using Access 97 on a Windows 98
machine.

Thanks!
Melinda