Hi,
I am having trouble doing a sort in a query (and report too)
I have a field called SP ITEM which looks up data in another table to get more information related to the SP ITEM.
Whenever I sort this SP ITEM it doesn't actually sort by the SP ITEM it sorts by the ID field from the other...