UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Need to sort on first char in field    
 
   
jan0902
post Apr 4 2007, 05:01 AM
Post #1

New Member
Posts: 7
From: Netherlands
Hello,

I'm trying to sort on the first char in a field. The first char is a "D" or a "H" or a "I" or a "O" . So the field contains
D1 till D999 or H1 till H999 and so on.
I made four queries with the Left$([fieldname];1)="D" and changed the "D" to "H".
How can I made this more simple.
The user must get a question to type the required letter? (Now it is done by a submenu)

could you please help me?
Go to the top of the page
 
+

Posts in this topic
- jan0902   Need to sort on first char in field   Apr 4 2007, 05:01 AM
- - djsteele   Re: Need to sort on first char in field   Apr 4 2007, 05:13 AM
- - jan0902   Re: Need to sort on first char in field   Apr 4 2007, 12:42 PM

« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 05:14 AM