Recent content by simonsimon

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

Thanks Heaps guys - worked perfectly!:) Simon

Hi all, I am having some problems with a query with related tables. I have one table that has master data for a specific equipment number. A second table is linked to this table detailing the area where it is kept where equipment is selected via a combo box. a third table has detailed notes...