sorting problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Isabelle
    #1

    sorting problem

    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!
    Tags: None
    • Reggie
      #2
      Re: sorting problem

      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

      https://www.smittysinet.com

      ----------
      "Isabelle" <isabelle16@hot mail.com> wrote in message
      news:9602e0e7.0 405210924.3be14 6df@posting.goo gle.com...[color=blue]
      > 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![/color]


        Comment

        Previous template Next
        Working...