The attached file shows reports displayed by ExhibitorID. I have tried unsuccessfully to rearrange these so they will appear in alphabetical order. No matter what grouping I use where there are Exhibitors with the same Surname the awards are being merged into one report. E.g. B Hollyman page 25 and N Hollyman page 33, also T and K MacKail on pages 31 and 32. Is it possible to group/sort these on Surname and Initial to have an alphabetical list and not a list based on ExhibitorID. Thanks.
Reports by alphabetical Order. (1 Viewer)
- Thread starter BillBee
- Start date
- Local time
- Today, 01:42
- Joined
- Sep 12, 2006
- Messages
- 15,748
sorting and grouping has to applied at the report level - not sure where it is, in A2007 ribbon, but you can probably right-click the report, and select sorting and grouping. select the fields you want - you will need 2 fields in this case - surname and forenames (or initials)
you also get header/footer options for each grouping item, so you can have a "pretty" header, or put toals in the footer.
if you used a wizard to design the report, you get asked questions about all this, but you may not have realised the significance.
you also get header/footer options for each grouping item, so you can have a "pretty" header, or put toals in the footer.
if you used a wizard to design the report, you get asked questions about all this, but you may not have realised the significance.
I have tried various combinations using grouping and sorting in the Form Design. Unless I use ExhibitorID I do not get all people getting their awards. Those with same surname get lumped together with the first exhibitor of that surname.
