Minty and Isladogs,
As for the DISTINCTROW in the query SQL I posted above, I should say I've never really written my queries in SQL. I normally build all my queries in the access query design window by adding tables and the fields I want to see; add any desired sorting; and then any necessary...