Gasman, GPGeorge,bastanu,theDBguy....
Thanks for your time and patience on this, i got well confused on this one and its working now how id like it, i went to try python and ended up with a mental block with vba....need to brush up on dao
Private Sub Command0_Click()
Dim DQRY As String
Dim dbs...