Re: automatic reordering for report

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 11/01/04 

Date: Mon, 01 Nov 2004 12:45:37 -0700

On Mon, 1 Nov 2004 01:09:03 -0800, "administrator"
<administrator@discussions.microsoft.com> wrote:

>welcome every body
>i create a programme that when the users select their names from a combolist
>a macro reade the time of selection then a report is printed contain the
>usernames and the coresponding times
>
>my question is that i need to make the report more inteligent which mean
>that the report make automatic reorder for the user names depending on the
>times which mean that the first user make selection be the first user in the
>report (on the top of report) and so on
>
>how to do this

You can only sort records on a Report based on data which exists in
the Report's recordsource query. If you have the time stored in a
table, use the Report's Sorting and Grouping property to sort by that
field.

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps

Relevant Pages

  • Re: Clear and Requery combo boxes
    ... Q3 - when a selection is made for the project team, ... When I close the report and go back ... >> The choices then generate a report based on the selection. ... >> Exit Sub ...
    (microsoft.public.access.formscoding)
  • Re: Option Groups
    ... Can't find "Command button report selection" even though I did a search. ... 'This procedure used inh Preview_Click and Print_Click Sub procedures. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: music popularity experiment
    ... On the face of the report, the first group selected their favourites based upon a positive reaction to what they heard thus giving a measure of 'quality'. ... We do not know the selection criteria of the second group but are led to the inference that their selection was based in whole or in part upon the new variable introduced, namely knowledge of the selections made by the first group. ... However, at least as reported, this doesn't give any insight in its own terms into real world behaviours since it is not apparent that there is a community of listeners exercising choice based solely on perception of musical quality which is in any position to influence the choice of the putative second group. ...
    (uk.music.folk)
  • Re: OpenReport action cancelled because of Printer
    ... You should be able to import the toolbar from the sample database with: ... setting my report toolbars to 'ReportToolbar' caused ... printer (I just clicked 'OK' with the 'use default printer' selection, ...
    (microsoft.public.access.reports)
  • Need help with multi threading, got error "Cross-thread operation.
    ... SortFields sortFields = rdLog.DataDefinition.SortFields; ... selection.", MessageBoxButtons.OK, MessageBoxIcon.Information); ... goto CleanUp; ... or clik the OK button to continue creating the report? ...
    (microsoft.public.dotnet.languages.csharp)