M?u bi?u th?c ? trch xu?t cc ph?n c?a m?t chu?i vn b?n trong truy c?p

D?ch tiu ? D?ch tiu ?
ID c?a bi: 286238 - Xem s?n ph?m m bi ny p d?ng vo.
V?a ph?i: ?i h?i v? m c b?n, m? ha, v k? nng kh? nng tng tc.

M?t phin b?n Microsoft Access 2000 c?a bi vi?t ny, xem cc 209045.
M?t phin b?n Microsoft truy c?p 97 c?a bi vi?t ny, xem cc 115915.
Bung t?t c? | Thu g?n t?t c?

TM T?T

Bi ny li?t k m?u bi?u th?c m b?n c th? s? d?ng ? trch xu?t m?t ph?n c?a m?t chu?i vn b?n. Nh?ng bi?u hi?n th?ng ?c s? d?ng trong cc C?p Nh?t vo d?ng c?a m?t truy v?n C?p Nh?t ? ?t m?t ph?n c?a m?t l?nh v?c l?n hn vo m?t l?nh v?c m?i. B?n c th? thch ?ng v?i cc bi?u hi?n do b?n c th? s? d?ng chng v?i cc ?nh d?ng ph? bi?n khc. V d?, b?n c th? s? d?ng bi?u th?c ?c s? d?ng ? gi?i nn "Doe" t? "Doe John" ? trch xu?t "Seattle" t? "seattle, WA."

THNG TIN THM

Nh?ng bi?u hi?n sau y l bi?u th?c m?u m b?n c th? s? d?ng ? gi?i nn m?t ph?n c?a m?t chu?i vn b?n.

LU ?: Trong nh?ng bi?u hi?n m?u sau, m?t g?ch d?i (_) ? ph?n cu?i c?a m?t ?ng ?c s? d?ng nh m?t k? t? ti?p t?c d?ng. Lo?i b? g?ch d?i t? cu?i d?ng khi ti t?o cc bi?u hi?n.

Tn ?u tin

G?c Entry trong [tn]: "john doe"
Quay tr? l?i b?i bi?u hi?n: John
Bi?u hi?n: Expr: tri ([tn], InStr(1,[Names],"")-1)

Tn ?u tin

Orignial m?c nh?p trong [tn]: "Doe John"
Quay tr? l?i b?i bi?u hi?n: John
Bi?u hi?n: Expr: Right(Trim([Names]),Len(Trim([Names]))-InStr (1, _
[Tn],""))

Tn ?u tin

G?c Entry trong [tn]: "John P. Doe"
Quay tr? l?i b?i bi?u hi?n: John
Bi?u hi?n: Expr: tri ([tn], InStr(1,[Names],"")-1)

Tn cu?i cng

G?c Entry trong [tn]: = "john doe"
Quay tr? l?i b?i bi?u hi?n: Doe
Expression:expr: Right(Trim([Names]),Len(Trim([Names]))-InStr (1, _
[Tn],""))

Tn cu?i cng

G?c Entry trong [tn]: "Doe John"
Quay tr? l?i b?i bi?u hi?n: Doe
Bi?u hi?n: Expr: Left([Names],InStr(1,[Names],",")-1)

Tn cu?i cng

G?c Entry trong [tn]: "John P. Doe"
Quay tr? l?i b?i bi?u hi?n: Doe
Bi?u hi?n: Expr: Right(Trim([Names]),Len(Trim([Names]))-InStr (InStr _
(1, [Tn],"") + 1, [tn], ""))

Tn cu?i cng

G?c Entry trong [tn]: "john doe" ho?c "John P. Doe"
Quay tr? l?i b?i bi?u hi?n: Doe
Bi?u hi?n: Expr: IIf (InStr (InStr ([tn],"") + 1, [tn],"") _
<>0, Quy?n ([tn], Len([names])-InStr (InStr ([tn],"") + 1, _
[tn],"")), ph?i ([tn], Len([names])-InStr([names], "")))

Trung ban ?u

G?c Entry trong [tn]: "John P. Doe"
Quay tr? l?i b?i bi?u hi?n: P.
Bi?u hi?n: Expr: c?t (lower ([tn], InStr (1, [tn],"") + 1, InStr (InStr _
(1, [Tn], "") + 1, [tn], "")-InStr (1, [tn], "")))

Trung ban ?u

G?c Entry trong [tn]: "Doe, John P."
Quay tr? l?i b?i bi?u hi?n: P.
Bi?u hi?n: Expr: Right(Trim([Names]),Len(Trim([Names]))-InStr _
(InStr (1, [tn],"") + 1, [tn],""))

Trung ban ?u

G?c Entry trong [tn]: "john doe" ho?c "John P. Doe"
Quay tr? l?i b?i bi?u hi?n: P. ho?c tr?ng
Bi?u hi?n: Expr: Trim (lower ([tn], InStr (1, [tn], "") + 1, IIf (InStr (InStr (1, [tn], "") + 1, [tn], "") = 0, 0, InStr (InStr (1, [tn], "") + 1, [tn], "")-InStr (1, [tn], ""))))

M? bu i?n

G?c Entry trong [ZipCode]: "98052-6399"
Quay tr? l?i b?i bi?u hi?n: 98052
Bi?u hi?n: Expr: Left([ZipCode],5)

M? vng

G?c Entry trong [i?n tho?i]: (425) 635-7050
Quay tr? l?i b?i bi?u hi?n: 425
Bi?u hi?n: Expr: lower ([i?n tho?i], 2, 3)

S? i?n tho?i

G?c Entry trong [i?n tho?i]: (425) 635-7050
Quay tr? l?i b?i bi?u hi?n: 635-7050
Bi?u hi?n: Expr: Right(Trim([Phone]),8)

Thu?c tnh

ID c?a bi: 286238 - L?n xem xt sau cng: 17 Thang Chin 2011 - Xem xt l?i: 3.0
p d?ng
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
T? kha:
kbhowto kbmt KB286238 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:286238

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com