RE: Report in Certain Order

Thanks OssieMac for your concise and prompt answer. Is there any way you can
use the Val function in a Combo Box so that the order is the same as the
report: 1A, 1B etc.

Thanks again

"OssieMac" wrote:

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: Sorting hidden columns
    ... "OssieMac" wrote: ... Sort Key is still first Data cell never the ... I have a macro that works fine when the columns are not hidden. ... Alternatively click on the row identifier 1 and then ...
    (microsoft.public.excel.misc)
  • RE: Report in Certain Order
    ... Thanks again OssieMac for your patience, ... Drag the field into the first column of the matrix. ... DO NOT set the sort for this column. ... Close the close X to close the query builder and select save at the prompt. ...
    (microsoft.public.access.gettingstarted)
  • RE: Sorting hidden columns
    ... I can definitely sort hidden columns if the columns are included in the range ... "OssieMac" wrote: ... I have a macro that works fine when the columns are not hidden. ... Alternatively click on the row identifier 1 and then ...
    (microsoft.public.excel.misc)
  • Re: change default numbering in access all versions
    ... If you want to sort a text field in number order then you have to force the text to become a number using the Val function or CDbl. ... Another alternative is to store all the text numbers with leading zeroes or force leading zeroes before you sort using the format function - ... i have other numeral columns without this type of confusion. ...
    (microsoft.public.access.queries)
  • Re: Group Header Sorting
    ... Use the Val function: add it as a computed field to the query, and then sort ... >I have a group header that I am using to sort data on a report. ...
    (microsoft.public.access.reports)