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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
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