Syntax error using dlookup

[Hugh self taught]

Hi All,

I have the following piece of code

ChkProv = DLookup("[Province_Cde]", "Provinces", "[Province_Cde]= ' " &
Left(Nat_Reg, 2))

which I want to use as part of validating that the 1st 2 left chrs of
Nat_Reg correspond with a record in field Province_Cde

However it gives me the following error when executed

Syntax error in string in query expression '[Province_Cde]='GU'

GU is valid in the record I was trying to add as a test & it exists in the
table Provinces.Province_Cde

Any suggestions on what to try to correct this?

Hugh

 

[John Spencer]

Missing a close quote mark and have a leading space in the third argument
before getting the two characters from Nat_Reg.

ChkProv = DLookup("Province_Cde", "Provinces", "Province_Cde= '" &
Left(Nat_Reg, 2) & "'")



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Marshall Barton]

ChkProv = DLookup("[Province_Cde]", "Provinces", "[Province_Cde]= ' " &
Left(Nat_Reg, 2))

which I want to use as part of validating that the 1st 2 left chrs of
Nat_Reg correspond with a record in field Province_Cde

However it gives me the following error when executed

Syntax error in string in query expression '[Province_Cde]='GU'

GU is valid in the record I was trying to add as a test & it exists in the
table Provinces.Province_Cde

You forgot the closing '

ChkProv = DLookup("[Province_Cde]", "Provinces",
"[Province_Cde]= '" & Left(Nat_Reg, 2) & "' ")

 

[Daniel Pineault]

You forgot your closing ', try:

ChkProv = DLookup("[Province_Cde]", "Provinces", "[Province_Cde]= ' " &
Left(Nat_Reg, 2) & "'")

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Hugh self taught]

Hi John, Marshall & Daniel

Many thanks for the help. Although my knowledge is growing I'm not
proficient at find my intricate errors yet. Works like a charm now

Hugh

Missing a close quote mark and have a leading space in the third argument
before getting the two characters from Nat_Reg.

ChkProv = DLookup("Province_Cde", "Provinces", "Province_Cde= '" &
Left(Nat_Reg, 2) & "'")



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hi All,

I have the following piece of code

ChkProv = DLookup("[Province_Cde]", "Provinces", "[Province_Cde]= ' " &
Left(Nat_Reg, 2))

which I want to use as part of validating that the 1st 2 left chrs of
Nat_Reg correspond with a record in field Province_Cde

However it gives me the following error when executed

Syntax error in string in query expression '[Province_Cde]='GU'

GU is valid in the record I was trying to add as a test & it exists in the
table Provinces.Province_Cde

Any suggestions on what to try to correct this?

Hugh

.