Re: Group Header Sorting
Use the Val function: add it as a computed field to the query, and then sort
on that field, rather than the original field.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"mcgj" <mcgj@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3374DEAC-2DE8-4CC9-A24B-AC61E3267282@xxxxxxxxxxxxxxxx
>I have a group header that I am using to sort data on a report. This
>header
> references a text (string) field in my table/query. This field has a
> mixture
> of some numbers and text in it. (Example:10A or 11-H or just 1 2 3 etc)
> So
> what I want my report to do is sort the data by the number it finds first
> (similar to the val function you can use in a query).
>
> Here is what I am getting now for my order
> 1
> 10A
> 11-H
> 2
> 3
>
> What I want is:
> 1
> 2
> 3
> 10A
> 11-H
>
> Does this make sense and can it be done???
.
Relevant Pages
- RE: Sorting in Query and Report involving look up combo box
... That is the problem with lookup fields. ... query and the report and the best way to do that is having the look up field. ... I have the report grouped by Artist Name and then Sorted by Style Number ... And, as I said before, Reports ignore the sort order of a query. ...
(microsoft.public.access.reports) - RE: Sorting in Query and Report involving look up combo box
... query and the report and the best way to do that is having the look up field. ... I have the report grouped by Artist Name and then Sorted by Style Number ... how do you have your sorting and grouping set up in your report. ... And, as I said before, Reports ignore the sort order of a query. ...
(microsoft.public.access.reports) - RE: Multiple sort query
... to sort by location, she would just select a person from the location drop ... then an employee from the drop down, and select run query. ... in turn run a report based on what was selected. ... list all employees they manage, a location report list all employees at that ...
(microsoft.public.access.queries) - Re: Report Sorting
... "ricseb" wrote: ... Sort by "Collection Date". ... query that has all of the above fields, but am at a loss as to how to ... populate this report in the above order. ...
(microsoft.public.access.reports) - RE: Separate Sort Order within same record
... If your report is not based upon a query then create one. ... Modify the query by opening in design view. ... Ascending or Descending in the Sort row remove the sort. ...
(microsoft.public.access.reports) |
|
