Thanks Rob.... I actually got it to work...now to comb my code and see where I can tighten it up using joins... > > I'm hollering... > > I need to understand this more fully. At the moment I am doing multiple > > selects from different tables and I know I should be able to use the one > > Sounds like you need SQL tutorials: > > http://w3.one.net/~jhoffman/sqltut.htm (the original and the best) > > http://www.sqlcourse.com/ (with nice interactive sql examples) > > http://www.sqlcourse2.com/ > > -- > > Rob Keniger