Link to home
Create AccountLog in
Avatar of mr_srahul
mr_srahul

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of supunr
supunr

OH, Dhaest and mine looks exactly the same... sorry Dhaest , did not copy from you.
remember, date is a reserved word.  therefore you need to use square brackets ([]) around that.
mr_srahul:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 -->Split between Dhaest and supunr

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER

GPrentice00
Cleanup Volunteer