Hi All I am trying to write a query on the Incident Assignment Log form. Basically we have 2 companies set up, say for example Company A and Company B. I want to get all the records which were initially assigned to Company A, but then were Re-Assigned to Company B. This is within Crystal, but currently my brain has switced off in anticipation of the week-end!! Any help would be greatly appreciated. Many thanks as ususal. Shafqat Ayaz
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"