Report By Name Order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a report to print the names in alpha order with a Group
header for the Alpha Prefix. The 'Sorting & Grouping' properties are set to
sort Name ascending, Group Header to Yes, Group on Prefix Characters, Group
Interval 1, Keep Together Whole Group. I have set the Header Properties
Force New Page to Before Section. The report is Ok except the Names are not
listed alphabetically under each Alpha Prefix. What else do I need to do?
Thanks for any help
Roger
 
in the Sorting & Grouping box, you might try adding the name field again,
under the first listing the includes the group header instruction. in the
second listing, don't change any of the Group Properties at the bottom of
the box, just set the Sort Order to ascending.

btw, i hope you don't actually have a field in any of your tables that's
called "Name". that's an Access Reserved Word and can cause lots of
headaches when you use it yourself to name something. if you continue to
have problems sorting on the "Name" field in the report, try this: in the
query underlying the report, create an alias for that field in query design
view, as
MyName: Name
it will show in the SQL statement as TheTableName.Name As MyName.
then you can use the alias in the report, rather than the "real" field name.

hth
 
Back
Top