function substr

[Guest]

Is function "substr" defined in MS Access?

 

[Dirk Goldgar]

Is function "substr" defined in MS Access?

No, but Mid() is probably a close equivalent.

 

[Guest]

thank you, Dirk.

But can you tell me what the syntex is for Mid().

 

[M.L. Sco Scofield]

Type "mid" into any code window and hit <F1>.

You can also get there by typing "mid function" into an Access help window,
selecting "Functions (alphabetical)", and scroll to the M's.

More than you ever wanted to know.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com