Partial Fields Criteria

[Guest]

I have two tables. Both have a field with the identical name. I have to
check the first 3 positions of the ZipCode for Certain States and the First 4
positions of Certain Other States.

I cannot find the proper syntax to do what I need to do.

One Table is Called NA and the update Table is AC. Both have ZipCode as a
Field

What I have is:

ExprC[NA]![ZipCode],3) in one column and ExprD[NA]![Zipcode],4) in the
other.

Does anyone know the proper Syntax?

I Have Played With It For Hours, But I am Begining To Run Out Of Time.

Thanks in Advance

Granny

 

[Lynn Trapp]

To get the first 3 characters of a field you use:

Left([ZipCode],3)

For the first for use:

Left([Zipcode],4)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html