At 11:12 AM 8/12/2003, fstorr wrote: >What I want to pull out of the query is >one term and two definitions and not the same term listed twice, once >for each defintion. Francis... You should deal with this in code. Just add a check to see if the current row has the same TermID as the last one. If yes, don't print the term, just the definition. -- Anthony Baratta President Keyboard Jockeys "Conformity is the refuge of the unimaginative."