RE: Separate Sort Order within same record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I tried to follow your instructions, unfortunately, I'm not too familiar with
queries and such. I followed through, but after pasting and saving and
re-opening, it still doesn't work. Is there no way to just hilight the
records you want to sort separately, rather than having to go into details
andand have to come up with more commands? It seems that this should have
been a simple task feature without having to go through all this.--
In God''s Harmony


"KARL DEWEY" wrote:

If your report is not based upon a query then create one. Then open the
report in design view and click on menu VIEW - Properties. Change the Record
Source property to the name of the query. Save and close.

Modify the query by opening in design view. If any of the fields have
Ascending or Descending in the Sort row remove the sort. Scroll the grid to
the right so that a blank column is in view. Copy and paste my post in the
Field row of the blank column. Edit it to have field names to be sorted on
in left to right order of high to low sort order (enclosed in brackets and
connected by ampersand.). Save and close.

Open the report in design view and click on menu VIEW - Sorting and
Grouping. In the new window select the Sort_Field. Save. Run.

--
KARL DEWEY
Build a little - Test a little


"Roddy" wrote:

Ken & Karl,

I appreciate your quick responses, but unfortunately I don't know how to go
about doing either of your solutions. If it's not too much to ask, could you
give me step-by-step instructions, including what menu to go to, etc. to do
this?
--
In God''s Harmony


"KARL DEWEY" wrote:

Try this calculated sort field ---
Sort_Field: IIF([style]= "Soundtracks", " " &[INSTRUMENT]& [ARTIST]&
[ALBUM]& [TITLE]& [YEAR], [Style]& [INSTRUMENT]& [ARTIST]& [ALBUM]& [TITLE]&
[YEAR])

The above will sort soundtracks at the top. If you use "ZZZZZ" in stead of
space then soundtracks will sort to the bottom.

--
KARL DEWEY
Build a little - Test a little


"Roddy" wrote:

I'm using Access 2002 and made up a report of my CD collection. I have
records with fields such as: STYLE, INSTRUMENT, ARTIST, ALBUM TITLE, YEAR,
etc.. I have all my records sorted by style, instrument, artists, album,
year, etc.

Is it possible to separately sort a specific range of records (say, all my
CDs under the style: "Soundtracks" without affecting the sort order of the
rest of the report?
--
In God''s Harmony
.

Relevant Pages

  • 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: pmj
    ... you have a fairly Confuzzled & unclear grasp of a lot of thoat sort ... Do sensible people *really* need to be told to read the Instructions? ... When people realise that buying & using a Computer (& the Internet) ... BTDTGTTS with one newbie who's pooter has spent more time ...
    (uk.people.silversurfers)
  • Re: bidding advice for a contract
    ... effort to complete the instructions before he returns. ... I do this sort of thing for a living, already having a full time job, ... etc. Buy it and adapt your business processes to the needs ... don't expect to have an immediate solution. ...
    (comp.lang.perl.misc)
  • Re: Learning assembly?
    ... Sort of instant assembly. ... (You can run the instructions in the ... ;-)) Very charming, for sure. ... the source editor, and then when you compile, the real compiler is handed ...
    (alt.lang.asm)
  • Newbie trying to install FrostWire.
    ... but I can't seem to sort this out in my head. ... I googled and ended up with this HowTo that is ... as per instructions, but could not find "java-package" with Synaptic, ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". ...
    (Debian-User)