this will be in vb. i attempted to use a select statement very similar to what smalig suggested but things don't seem to be working properly. i've pretty much decided to cry uncle and purchased sql for dummies over the weekend.