Compile Error When running a simple query

[Kully121]

Hi,


Had MS Access installed however keep getting a 'COMPILE Error in query expression' when running a simple query


(Left([Field 1],2)

 

[Norie]

Is [Field 1] text ?

 

[Kully121]

Yes it's a text field in a linked table

 

[Andrew Fergus]

Hi Kully121 and welcome

Try remove the leading bracket, it looks like you have 2 left brackets and 1 right bracket.

Andrew.

 

[Kully121]

Hi

Apologies should read

Left([Field1],4)

I think its something to do with the settings as it works on a collegues ms access

 

[Andrew Fergus]

AFAIK the "left" function isn't an add-in - is it "Field1" or "Field 1"?

A

 

[Andrew Fergus]

Are there any values in Field 1 with less than 4 characters?

 

[Norie]

less than 4 characters?

Surely you mean less than 2?

 

[Andrew Fergus]

Surely you mean less than 2?

Hi Norie,
check out the 3rd post from Kully121
A.

 

[Norie]

Andrew

Never saw that.