i agree with that my suggestion was to change the table into 2 tables master/detail but had no say in the final outcome. so i am stuck with using the long query...