Thanks, got it by just running the total based on the group criteria. thanks again for the fast reply.