Much thanks to GideonOmega for his help. for sure i would be bald by now if he didn't help me with my project.
next quest.... based on the values inputed into the labels on my form, i want to use a between instead of = . how in the world do you give a range in a SQL statement when you don't know the value that is going to be used for the search.
i'll post a statement soon to let you know how