RE: Advanced sort

No, insert a new column and paste what I posted editing it to use your field
name.
--
KARL DEWEY
Build a little - Test a little


"Cath" wrote:

When you say to add a calculated field ...you mean in the CRITERIA box?

"KARL DEWEY" wrote:

I want to sort in ascending order but from the 4th number
I assume that you do not want to ignore the rest of the data in the process
of sorting.
You can open your query in design view and add a calculated field to sort on
like this --
My_Sort: Right([MyDataField],2) & [MyDataField]
I assume that you do not want to ignore the rest of the data in the process
of sorting I added the "& [MyDataField]" for a complete sort.

--
KARL DEWEY
Build a little - Test a little


"Cath" wrote:

Hi,
I am trying to sort some data in a report. What I am trying to do is for
exemple, I have these datas: 20056, 10048, 60071, 30025

I want to sort in ascending order but from the 4th number, like this:

30025
10048
20056
60071

Is it possible?

Thank you

.

Relevant Pages

  • RE: Want a counter for Access Query results
    ... "Stegra" wrote: ... "KARL DEWEY" wrote: ... Second sort - Date or Name or Time ...etc ... Have counter start on the main sort (req number) and count until that main ...
    (microsoft.public.access.queries)
  • RE: Separate Sort Order within same record
    ... Name, Artist First Name, Year of Album, and finally the actual Album Title). ... bad, if it had the ability to sort through all columns like in Access, I ... "KARL DEWEY" wrote: ... soundtracks, and the sort order for the soundtracks. ...
    (microsoft.public.access.reports)
  • RE: Sorting Dates
    ... Try reversing the entire sort? ... "KARL DEWEY" wrote: ... Seniority Date/Hire Date seems to be where the trouble is. ... with the exact same total of overtime hours, ...
    (microsoft.public.access.reports)
  • RE: Separate Sort Order within same record
    ... "KARL DEWEY" wrote: ... Ascending or Descending in the Sort row remove the sort. ... give me step-by-step instructions, including what menu to go to, etc. to do ... The above will sort soundtracks at the top. ...
    (microsoft.public.access.reports)
  • Re: My Sort Wont Sort
    ... On Mar 26, 11:11 am, KARL DEWEY ... Note that Reports do NOT honor their recordsource query's sort ... GBP_2007.PlayerID) INNER JOIN HCRLTeams ON DraftTracker.HCRLTeam = ...
    (microsoft.public.access.queries)