troubleshooting Question

Query in vb database  is MS ACCESS

Avatar of mr_srahul
mr_srahul asked on
Visual Basic Classic
6 Comments2 Solutions147 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Dirk Haest
Project manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros