sorting problem

[Isabelle]

Hi there,

I've made a report that shows the purchases my company has made based
and the purchases are sorted by supplier. The problem is that I'd
like to have the suppliers listed in alphabetical order but it is
listing it according to SupplierID (Sigma, Upstat, Bureau, etc instead
of Bureau, Sigma, Upstat, etc.). The control is set as Supplier ID
and sorted ascending, so I understand why it is doing this. When I
try to set the control as SupplierName, I get the message "The value
you entered isn't valid for this field. For example you may have
entered text in a numeric field". When I check the suppliers,
purchase orders and inventory transactions tables Supplier Name format
is set to text in all of them. Can any give me a hint as to why it
thinks it's not text, or does any one know how I can resort the
Supplier ID so that it comes out in alphabetical?

Much thanks in advance for any help provided!

[Reggie]

You could design a query and set the recordsource for the report to the name
of the query. In the query you can sort the records as you like. As far as
the "Control" being set to Supplier ID I assume you are using the Sorting
and Grouping function in the report. If so add/select the SupplierName from
the list. Highlight it and drag it above the Supplier ID field.

--
Reggie

www.smittysinet.com
----------
"Isabelle" <is********@hotmail.com> wrote in message
news:96**************************@posting.google.c om...

Hi there,

I've made a report that shows the purchases my company has made based
and the purchases are sorted by supplier. The problem is that I'd
like to have the suppliers listed in alphabetical order but it is
listing it according to SupplierID (Sigma, Upstat, Bureau, etc instead
of Bureau, Sigma, Upstat, etc.). The control is set as Supplier ID
and sorted ascending, so I understand why it is doing this. When I
try to set the control as SupplierName, I get the message "The value
you entered isn't valid for this field. For example you may have
entered text in a numeric field". When I check the suppliers,
purchase orders and inventory transactions tables Supplier Name format
is set to text in all of them. Can any give me a hint as to why it
thinks it's not text, or does any one know how I can resort the
Supplier ID so that it comes out in alphabetical?

Much thanks in advance for any help provided!