Sorting Problem!

  • Thread starter Thread starter TASHA
  • Start date Start date
T

TASHA

I have a table:Brokers. The list is sorted by the Broker's
name. I have a report that prints a summary using the
brokername as one of its fields. Every time I add a new
entry to the Brokers table & print the report, the new
entries go to the bottom of the report instead of re-
sorting alphabetically. I have tried everyting and can not
get the BrokerName field to re-sort. Please help,

Sincerely,
Frustrated Database Bulider
 
-----Original Message-----
I have a table:Brokers. The list is sorted by the Broker's
name. I have a report that prints a summary using the
brokername as one of its fields. Every time I add a new
entry to the Brokers table & print the report, the new
entries go to the bottom of the report instead of re-
sorting alphabetically. I have tried everyting and can not
get the BrokerName field to re-sort. Please help,

Sincerely,
Frustrated Database Bulider
.
You can try one of 2 things. The first is to resort the
Click to expand...
table by broker name after you make a new entry. The
second, which is actually my choice would be in the form
use the sorting and grouping feature and sort on Broker in
ascending order. This when you add a new broker and print
the report it will always be in order.
 
Are you sorting in the report or in the query? Query sorts have absolutely
no influence on report sorting order. If your sorting is in the report, then
I suspect you are using the horrible feature of Lookup fields.
 
Back
Top