extract value

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Queries / May 2005

extract value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stevensZoe - 16 May 2005 14:55 GMT

i need assistance extract the following

12345 from 3001-12345Y
6534 from 2007-6534Z

thank you

Reply to this Message

Rick B - 16 May 2005 15:47 GMT

Mid([SomeFieldName],6,4)

Signature

Rick B

> i need assistance extract the following
>
> 12345 from 3001-12345Y
> 6534 from 2007-6534Z
>
> thank you

Reply to this Message

stevenszoe - 16 May 2005 16:47 GMT

thank rick. but if I have a value 2007-653Z I am getting 653z. I am needing
just 653. the number of digits before the letter is variable.

> Mid([SomeFieldName],6,4)
>
[quoted text clipped - 4 lines]
> >
> > thank you

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.