accessman2
Registered User.
- Local time
- Yesterday, 21:46
- Joined
- Sep 15, 2005
- Messages
- 335
Hi,
In MS Access,
I create many queries to do calculation of the data, and also the queries contents have been changed depend on the user what criteria values input on the form. And then export the final results to the Excel worksheets.
In VB2005, can we do that?
For example:
qry1: retrieve data from table 1 where [Name] = "xxxx"
qry2: retrieve data from table 2 where [Month] = "July-07"
qry3: qry1 Left Join qry2
qry4: Sum(qry3.fieldname) Group By qry3.fieldnames
qry5: retrieve data from table 3 where [Student] = "xxxx"
qry6: Sum(qry5.fieldname) Group By qry5.fieldnames
.....
qry10: do crosstab query.
Export qry10 results to Excel worksheets.
In MS Access, I can do it.
Can we create many temporary queries and setup the temporary name of each query in VB2005?
In MS Access,
I create many queries to do calculation of the data, and also the queries contents have been changed depend on the user what criteria values input on the form. And then export the final results to the Excel worksheets.
In VB2005, can we do that?
For example:
qry1: retrieve data from table 1 where [Name] = "xxxx"
qry2: retrieve data from table 2 where [Month] = "July-07"
qry3: qry1 Left Join qry2
qry4: Sum(qry3.fieldname) Group By qry3.fieldnames
qry5: retrieve data from table 3 where [Student] = "xxxx"
qry6: Sum(qry5.fieldname) Group By qry5.fieldnames
.....
qry10: do crosstab query.
Export qry10 results to Excel worksheets.
In MS Access, I can do it.
Can we create many temporary queries and setup the temporary name of each query in VB2005?