sort order in report

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

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?
 
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


Carlee said:
Hi there. I have a one to many relationship between my client and
Click to expand...
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
Click to expand...
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
Click to expand...
alphabetically. It sorts numerically. How can I get it to sort
alphabetically?
 
Back
Top