Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a 20 character filed that I would like to sort by the last character,
can this be done? Also, can a drop down box pull up information based on the
last character but keep the data in the order it was entered?

THanks
Joe
 
I have a 20 character filed that I would like to sort by the last character,
can this be done? Also, can a drop down box pull up information based on the
last character but keep the data in the order it was entered?

THanks
Joe
Click to expand...

Add a new column to the query.

SortThis:Right([AFieldName],1)
Sort by this column

As to your second question, probably, but you haven't given enough
information so I can't advise you as to how.
 
This is the type of data I am using.

L4N4K113K234ANG29DMA
L1N4K113K284ANR290MD
L3N4K113K234ANG29DMC
L4N4K113K234ANG29DMA
L2N4K113K234ANG29DMB

What I was wondering is, in a drop down box can I enter just the letter A
and have the drop down list all the matching items ending in A and show them
without rearranging the order of the characters?

Thanks
Joe

fredg said:
I have a 20 character filed that I would like to sort by the last character,
can this be done? Also, can a drop down box pull up information based on the
last character but keep the data in the order it was entered?

THanks
Joe
Click to expand...

Add a new column to the query.

SortThis:Right([AFieldName],1)
Sort by this column

As to your second question, probably, but you haven't given enough
information so I can't advise you as to how.
Click to expand...
 
I have a 20 character filed that I would like to sort by the last character,
can this be done? Also, can a drop down box pull up information based on the
last character but keep the data in the order it was entered?

THanks
Joe
Click to expand...

Add a new column to the query.
SortByThis:Right([FieldName],1)

Sort on this column.

You'll need to be more specific regarding your second question. A few
examples perhaps.
 
Back
Top