Query in vb database is MS ACCESS

I have to retrieve a set of records from the database(MS ACCESS)
When i used the query in sql promt it works the query i typed is

select vprice from veh where vname='tvs champ' and vcolor='blue'

The problem is that vname('tvs champ')and vcolor('blue') has to be got from
from the combo1 and combo2 boxes
Please tell me the approriate query that should be given in vb

Another doubt

 i have to display a set of record in the data report ,my table contains the fallowing
fields

table name :sales
fields:
date
cname(customer name)
vname(vehicle name)
price

i have to display all the customer name who have bought the vehicle between
1/1/2003 to 1/5/2003
how can i do it
please help me