RE: Report in Certain Order

Tech-Archive recommends: Fix windows errors by optimizing your registry

I should have also said that the virtual field needs to be to the left of the
real field that has both both numeric and text. This is so the numeric sort
becomes the primary sort. You will also need to have the text and numbers
field sort set to ascending so that it becomes the secondary sort otherwise
your alpha characters may not be in order.

--
Regards,

OssieMac


"OssieMac" wrote:

Create a virtual field in the report query as Val([YourField])

Set sort for this field to Ascending.

Val function reads the text up to last numeric and creates a real number so
your sort works as required.

Don't know how much instruction you need but get back to me if you need more
info to do this.

--
Regards,

OssieMac


"Roger Bell" wrote:

I have a Report that is sorted on Plot Numbers which is a Text Field and
includes Entries like 1A, 1B, 2A, 2B etc.

The problem is that when I run the Report the entries list as 10A, 10B, then
down the list is 1A etc. I would like the report to list 1A, 1B, 2A, 2B, 3A,
3B etc in that order.

Is there any way I can achieve this?

Thanks for any help
.

Relevant Pages

  • Re: Module Cruelly Kissed to Death by -O2
    ... It makes a huge difference in a merge sort and brings g95's ... descending 0. ... ascending 0. ...
    (comp.lang.fortran)
  • Re: finding & sorting unqiue names list
    ... this formula return unique value and sort ascendenting.. ... i wish to extract a list of the unique names ... > sorted out in either ascending or descending order. ... > cell B1, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Inidicator Arrow convention for Sort Order
    ... For an ascending sort the bigger numbers are at the bottom. ... I would propose to use an unambiguous convention, ...
    (comp.lang.java.gui)
  • Re: Sorting
    ... Hi Dave, ... I don't know if you are showing all of the data necessary ... sort on Column B, Column C, Column D all ascending ...
    (microsoft.public.excel.programming)
  • Re: Insert rows based on specific value
    ... If you sort (ascending) on column U alone, that should work to move the new ... there will be 25 ties for Atl.. ... The 2nd formula must count the entries in *all of the cells above it*, ...
    (microsoft.public.excel.worksheet.functions)