•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 426,883 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,359 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 387 | Replies: 3
 |
•
•
Join Date: Jun 2007
Location: india /bangalore
Posts: 18
Reputation: 
Rep Power: 2
Solved Threads: 0
Newbie Poster
hello ..this problem i am posting 3rd time still not resolved
i aam trying to develop a project using vb and access
i have got a problem
i have 3 tables in access
1.Cust info table(fields are listed below)
cust id,name,age,sex,country...etcxc(primary key cust id)
2,indate(fields are listed below)
custid ,packageid,date,intime,outime(no primary key)
3.package info table(fields are listed below
package id, package name,duration ,price(primary key packageid)
tthese three tables are connected...the attachment shows how it is connected
i want to write a query to select custid, custname,packageid,packagename,duration,price,date,timein,timeout from these tables in vb..n in a data grid to display these.
this has been solved by the following query
Select CI.name,I.ServiceID,P.packagename,P.duration,P.price,I.date,I.timeIn,I.timeOut
From CustInfo CI, InDate I, PakInfo P Where CI.CustID = I.CustID And I.ServiceID = P.ServiceID Order By CI.Name
now the problem is
i want to put two dtpicker one for from date and the other todate..when the user slects a range from the dtpicker fromdtpiker and todtpicker the records in the data grid shud be within that range(i e only those transactions shud be seen).can anyone tell me how to do that,,and one more thing there is a textbox to display the total. in that label it shud sum up all the price column listed in side the datagrid respect to the month selected by the user
can any one help me with this[/quote]
any
i aam trying to develop a project using vb and access
i have got a problem
i have 3 tables in access
1.Cust info table(fields are listed below)
cust id,name,age,sex,country...etcxc(primary key cust id)
2,indate(fields are listed below)
custid ,packageid,date,intime,outime(no primary key)
3.package info table(fields are listed below
package id, package name,duration ,price(primary key packageid)
tthese three tables are connected...the attachment shows how it is connected
i want to write a query to select custid, custname,packageid,packagename,duration,price,date,timein,timeout from these tables in vb..n in a data grid to display these.
this has been solved by the following query
Select CI.name,I.ServiceID,P.packagename,P.duration,P.price,I.date,I.timeIn,I.timeOut
From CustInfo CI, InDate I, PakInfo P Where CI.CustID = I.CustID And I.ServiceID = P.ServiceID Order By CI.Name
now the problem is
i want to put two dtpicker one for from date and the other todate..when the user slects a range from the dtpicker fromdtpiker and todtpicker the records in the data grid shud be within that range(i e only those transactions shud be seen).can anyone tell me how to do that,,and one more thing there is a textbox to display the total. in that label it shud sum up all the price column listed in side the datagrid respect to the month selected by the user
can any one help me with this[/quote]
any
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,585
Reputation: 
Rep Power: 11
Solved Threads: 235
don't post thread like this again...
use your previous thread, don't make this forum full with your multiple thread. you just ask again in same post.
use your previous thread, don't make this forum full with your multiple thread. you just ask again in same post.
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
•
•
Join Date: Jun 2007
Posts: 78
Reputation:
Rep Power: 2
Solved Threads: 6
Junior Poster in Training
hi,
Try to avoid Posting the same.
Try Below query:
Select CI.name,I.ServiceID,P.packagename,P.duration,sum(p.price),P.price,I.date,I.timeIn,I.timeOut
From CustInfo CI, InDate I, PakInfo P Where CI.CustID = I.CustID And I.ServiceID = P.ServiceID and indate.intime>='" & dtpicker1.text & "' and indate.outime<='" & dtpicker2.text & "'
group by CI.name,I.ServiceID,P.packagename,P.duration,P.price,I.date,I.timeIn,I.timeOut
Order By CI.Name
Have a nice day.
Shailaja
any[/quote]
Try to avoid Posting the same.
Try Below query:
Select CI.name,I.ServiceID,P.packagename,P.duration,sum(p.price),P.price,I.date,I.timeIn,I.timeOut
From CustInfo CI, InDate I, PakInfo P Where CI.CustID = I.CustID And I.ServiceID = P.ServiceID and indate.intime>='" & dtpicker1.text & "' and indate.outime<='" & dtpicker2.text & "'
group by CI.name,I.ServiceID,P.packagename,P.duration,P.price,I.date,I.timeIn,I.timeOut
Order By CI.Name
Have a nice day.
Shailaja •
•
•
•
Originally Posted by ITech 
hello ..this problem i am posting 3rd time still not resolved
i aam trying to develop a project using vb and access
i have got a problem
i have 3 tables in access
1.Cust info table(fields are listed below)
cust id,name,age,sex,country...etcxc(primary key cust id)
2,indate(fields are listed below)
custid ,packageid,date,intime,outime(no primary key)
3.package info table(fields are listed below
package id, package name,duration ,price(primary key packageid)
tthese three tables are connected...the attachment shows how it is connected
i want to write a query to select custid, custname,packageid,packagename,duration,price,date,timein,timeout from these tables in vb..n in a data grid to display these.
this has been solved by the following query
Select CI.name,I.ServiceID,P.packagename,P.duration,P.price,I.date,I.timeIn,I.timeOut
From CustInfo CI, InDate I, PakInfo P Where CI.CustID = I.CustID And I.ServiceID = P.ServiceID Order By CI.Name
now the problem is
i want to put two dtpicker one for from date and the other todate..when the user slects a range from the dtpicker fromdtpiker and todtpicker the records in the data grid shud be within that range(i e only those transactions shud be seen).can anyone tell me how to do that,,and one more thing there is a textbox to display the total. in that label it shud sum up all the price column listed in side the datagrid respect to the month selected by the user
can any one help me with this
•
•
Join Date: Jul 2007
Location: Philippines
Posts: 205
Reputation:
Rep Power: 0
Solved Threads: 22
Posting Whiz in Training
Dont you know your molesting everyone here?! the way you post your thread makes us ...... !!!
Curiosity! Does it mean ignorance?http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Simple login (read data through txt file)
- Next Thread: How i could have a web address for download music from radio station?
