Sort

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

Guest

I would like to enter a sorting reference into a report. Our customer numbers
are looking like the following: 43001000-6000 . Only the last four numbers
are counting up (6000,6001,6002,6003 ... etc) the first 8 numbers are
sometimes different.
So, I would like to sort my report by customer number - but sorted ONLY on
the last 4 numbers.
How does the expression look like?
Thanks
 
Amateur said:
I would like to enter a sorting reference into a report. Our customer numbers
are looking like the following: 43001000-6000 . Only the last four numbers
are counting up (6000,6001,6002,6003 ... etc) the first 8 numbers are
sometimes different.
So, I would like to sort my report by customer number - but sorted ONLY on
the last 4 numbers.
Click to expand...


Set the report's Sorting and Grouping to sort on the
expression:

=Right(cusomernumberfield, 4)
 
Marsh provided a good answer. Please be more specific than "it's not
working".

Hint: if you create field names with space and/or symbols, you must wrap
those names in [ ]s. This is true almost every where you can enter a field
or other object name.

Try:
=Right([Customer ID:], 4)
This assumes you have a space and a colon in your field name. It looks more
like you might have used the field Caption property.

Hint number 2: IMHO don't ever use field caption properties in your table
design.
 
Thanks Duane, I believe with all this Access things since weeks I am starting
to get confused and forgetting the basic rules. Thanks for remainding me
again. It helped.
Thanks again. Could you please look into my question Print - URGENT ?
Maybe you have a solution for that as well.

Duane Hookom said:
Marsh provided a good answer. Please be more specific than "it's not
working".

Hint: if you create field names with space and/or symbols, you must wrap
those names in [ ]s. This is true almost every where you can enter a field
or other object name.

Try:
=Right([Customer ID:], 4)
This assumes you have a space and a colon in your field name. It looks more
like you might have used the field Caption property.

Hint number 2: IMHO don't ever use field caption properties in your table
design.

--
Duane Hookom
MS Access MVP
--

Amateur said:
I tried =Right(Customer ID:, 4) it's not working. Any other idea?
Thanks Klaus
Click to expand...
Click to expand...
 
You got the best advice from Terry.

--
Duane Hookom
MS Access MVP
--

Amateur said:
Thanks Duane, I believe with all this Access things since weeks I am
starting
to get confused and forgetting the basic rules. Thanks for remainding me
again. It helped.
Thanks again. Could you please look into my question Print - URGENT ?
Maybe you have a solution for that as well.

Duane Hookom said:
Marsh provided a good answer. Please be more specific than "it's not
working".

Hint: if you create field names with space and/or symbols, you must wrap
those names in [ ]s. This is true almost every where you can enter a
field
or other object name.

Try:
=Right([Customer ID:], 4)
This assumes you have a space and a colon in your field name. It looks
more
like you might have used the field Caption property.

Hint number 2: IMHO don't ever use field caption properties in your table
design.

--
Duane Hookom
MS Access MVP
--

Amateur said:
I tried =Right(Customer ID:, 4) it's not working. Any other idea?
Thanks Klaus

:

Amateur wrote:

I would like to enter a sorting reference into a report. Our customer
numbers
are looking like the following: 43001000-6000 . Only the last four
numbers
are counting up (6000,6001,6002,6003 ... etc) the first 8 numbers are
sometimes different.
So, I would like to sort my report by customer number - but sorted
ONLY
on
the last 4 numbers.


Set the report's Sorting and Grouping to sort on the
expression:

=Right(cusomernumberfield, 4)
Click to expand...
Click to expand...
Click to expand...
 
Back
Top