Re: [MS_AccessPros] Sort Order Left and Right

 

Khalid-

SortOrder: Left([CollectionVoucher].[ConsignmentNo], 4) & Right([CollectionVoucher],[ConsignmentNo], 2)

I'm surprised you couldn't figure that out on your own.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Jan 4, 2014, at 9:30 AM, Khalid Tanweer <khalidtanweerburrah@yahoo.com> wrote:

Hi all,

I need to modify the following expression in a query to sort from LEFT 4 spaces and from RIGHT 2 spaces, currently its for only RIGHT

SortOrder: Right(CollectionVoucher.ConsignmentNo,2)

Thanks all in advance.

Khalid

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___