[MS_AccessPros] Sort Order Left and Right

 

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 (1)

Recent Activity:

• New Members 1

Visit Your Group

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

.

__,_._,___