Sort Report

"Nylex" <Nylex.DeleteThis@discussions.microsoft.com> wrote

> When I open the "Sorting and Grouping" it has in it on the 1st line
> "Order.OrderID" Ascending and the Report prints the Heading and all the
> details correctly and in the Details section prints the 11 entries that
> have
> been made against this quote
> When I change the 1st line in the box to be "ProductID" Ascending then the
> heading prints out but in the details section only 1 item prints and it
> isnt
> even the one that starts with "B" which it should be if it is sorting
> properly
> Should I leave the first line and put the next entry on the second line??

There seems to be some discrepancy, or I am misunderstanding... in my Tables
a field named "ProductID" would be a numeric field used as a key, and
"Product Desc" would be a text description. If you want the data sorted
alphabetically by "Product Desc" then you have to use whatever Field is the
one displayed under that heading.

If you are printing more than one Order in this Report, you would definitely
need to leave in the first line, and add the Sort by Product Description.

From your description, you made a change that grouped on each Product ID
(each line intended to be a detail line).

Larry Linson
Microsoft Office Access MVP

The "ProductID" field is linked to the products table which has an ProductID
which is the Key and then it has "Description" field and then "BarCode" field
Changing the sort to Ascending or Descinding alter the printout - on
checking each item I find that the ProductID field has a number in it and the
Report has it as a Combo Box - when the report prints it prints the Desc not
the number and then on the same line it prints the barcode no - to get it to
do this I have in the Report form the following
=DLookUp("BarCode","Products","ProductID= " & [ProductID])
Do I have to do the same sort of lookup and get the desc so that I can sort

"Larry Linson" wrote:

>
> "Nylex" <Nylex.RemoveThis@discussions.microsoft.com> wrote
>
> > When I open the "Sorting and Grouping" it has in it on the 1st line
> > "Order.OrderID" Ascending and the Report prints the Heading and all the
> > details correctly and in the Details section prints the 11 entries that
> > have
> > been made against this quote
> > When I change the 1st line in the box to be "ProductID" Ascending then the
> > heading prints out but in the details section only 1 item prints and it
> > isnt
> > even the one that starts with "B" which it should be if it is sorting
> > properly
> > Should I leave the first line and put the next entry on the second line??
>
> There seems to be some discrepancy, or I am misunderstanding... in my Tables
> a field named "ProductID" would be a numeric field used as a key, and
> "Product Desc" would be a text description. If you want the data sorted
> alphabetically by "Product Desc" then you have to use whatever Field is the
> one displayed under that heading.
>
> If you are printing more than one Order in this Report, you would definitely
> need to leave in the first line, and add the Sort by Product Description.
>
> From your description, you made a change that grouped on each Product ID
> (each line intended to be a detail line).
>
> Larry Linson
> Microsoft Office Access MVP
>
>
>