Thanks for the reply. I have worked around the immediate problem and am really interested in getting the view designer (or me) to work better. I can't make the view designer group my WHERE conditions properly. Any help here would be appreciated.