Re: Sorting Report

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Wed, 26 Apr 2006 12:33:02 -0700, Debra Ann wrote:

I have a report that is looking at a table. Within the report, I have a
textbox that equal the combination of a bunch of fields in the table:

=[nonisoDocIdentifier] & "-" & [nonisoUnitIdentifier] & "-" &
[nonisoDisciplineCode] & [nonisoDocumentTypeCode] & "-" & [nonisoSSCCode] &
"-" & [nonisoElevationNumber] & "-" & [nonisoDrawingSize]

I want the report to sort by the above combination of fields. How do I do
that. When I do OrderBy =[TextBox] and OrderByOn = Yes, it comes up with an
error.

thanks,

Reports should be sorted in it's Sorting and Grouping dialog.

Create a query that will be the record source of the report.
In that query, add a new column.

SortThis:[nonisoDocIdentifier] & "-" & [nonisoUnitIdentifier] & "-" &
[nonisoDisciplineCode] & [nonisoDocumentTypeCode] & "-" &
[nonisoSSCCode] & "-" & [nonisoElevationNumber] & "-" &
[nonisoDrawingSize]

Save the query.

Open the report in Design View.
Change the report's Record Source to this query.
Save the change.

Then click on View + Sorting and Grouping
Set the Field/Expression drop down to [SortThis]

Then replace that current text box with the above expression in the
report with a control bound to the SortThis field in the query.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • RE: Combo Box Problem
    ... "Your Record Source query doesn't appear to have an filter. ... record source query it won't display in the report? ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: Query form coding
    ... The record source for the list box "namelst" is: ... The report record source seems to give the desired records. ... The code for the button (create the filter) works if no names have been selected in the names list box. ... I have tried to include the query when using the wizard to design the report but I keep getting an error saying I have used a table or query that is based on a table or query and when I remove the query fields from the list it allow me to continue with the report design. ...
    (microsoft.public.access.formscoding)
  • Re: Create sums on different groupings?
    ... You could base your main report on the group by and totals query I suggested ... by Name, date, and Amount. ... Then add this query to your report's record source so you have the 375" ...
    (microsoft.public.access.reports)
  • Re: Create sums on different groupings?
    ... I used Query1 as the record source for the main report and Query2 as the ... "Duane Hookom" wrote: ... You could base your main report on the group by and totals query I ...
    (microsoft.public.access.reports)
  • Re: Create sums on different groupings?
    ... I used Query1 as the record source for the main report and Query2 as the ... "Duane Hookom" wrote: ... You could base your main report on the group by and totals query I suggested ...
    (microsoft.public.access.reports)