Sorting Problem!

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
 
D

Dorothy

-----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
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.
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top