sort order in report

[Guest]

Hi there. I have a one to many relationship between my client and shipment tables. In shipment i have consignee and consignor fields. These two fields are forgien keys in the one to many relationship of Client and Shipment. (a consignee can also be a consignor)

in my table design, i have a combo box which shows the names of the clients, and in teh table the number is stored.

Problem:

When i run a report i was to sort by Consignee, but it doesn't sort alphabetically. It sorts numerically. How can I get it to sort alphabetically?

 

[Duane Hookom]

Add the table with the Consignee name field into your report's record
source. Open the Sorting and Grouping dialog and select the appropriate
fields.

--
Duane Hookom
MS Access MVP

Hi there. I have a one to many relationship between my client and

shipment tables. In shipment i have consignee and consignor fields. These
two fields are forgien keys in the one to many relationship of Client and
Shipment. (a consignee can also be a consignor)

in my table design, i have a combo box which shows the names of the

clients, and in teh table the number is stored.

Problem:

When i run a report i was to sort by Consignee, but it doesn't sort

alphabetically. It sorts numerically. How can I get it to sort
alphabetically?