Add a 0

[bolson7117]

hey all,

If i wanted to add a 0 in front of this Mid express i have already got where would i place it at. I'm also wondering how I can add a non-existing field to my Querie. For example I wanted to have every record have NE as a my state field.

SECTION: Mid([CAR1_CAV_MEMBERDETL.LOCATION],7,2)

thanks for the help

 

[tehNellie]

in Design View syntax:
Section: "0" & Mid([CAR1_CAV_MEMBERDETL].[LOCATION],7,2)
State: "NE"

in SQL

SELECT "0" & Mid([CAR1_CAV_MEMBERDETL].[LOCATION],7,2) as section, "NE" as State
FROM CAR1_CAV_MEMBERDETL

Should do it.

 

[bolson7117]

O yea Thanks A-Lot!

 

[bolson7117]

Ok now that i have that how would a add something like this, do i use a & as well.

Township Direction: Mid([CAR1_CAV_MEMBERDETL.LOCATION],13,1)

-up- this is just giving me a 1 or a 2 and all i want to do is do a Switch or Replace command with this. 1=E and 2=W.

Switch([CAR1_CAV_MEMBERDETL.LOCATION]="1","E")