	AllExperts > Visual Basic
	Search

About Ravindra
Expertise
visual basic application programming from design to access information, sql, engineering and commercial applications. access databases, excel.(VB6) basic questions in vb 2008. Optional: 1)a large number of people want me to do work which takes some time and effort. can do projects in vb 2008. Pl.note that i would like to be paid for such work. 2) if you want me to spend quality time and do special work, i expect to be paid a reasonable price for my time. 3) if you are pleased with my reply you could consider a donation of 1$. 4) you can visit my website http://ravindra.coolpage.biz

Experience

Education/Credentials
engineering, management degrees.

Past/Present Clients
project work for a Norway company,USA company and a Canadian company completed. Freelance Project work and Teaching. helping programmers with their work
teaching vb

You are here: Experts > Computing/Technology > Basic > Visual Basic > visual basic 6.0 and data report

Visual Basic - visual basic 6.0 and data report

Expert: Ravindra - 10/22/2009

Question
i have following tables in my database
master-containing all account no
transaction2007-containing account no with debit nad credit
transaction2006-same as above
transaction2008-same as above
i want to generate data report that shud display the detials from transaction table wen user enter the particular year it shud display detail of that year.

dont want to use union of all the tables
is it possible to do grouping in data report
1.A-main account
.a.AC
.*.AC1001
.*.AC1002
b.AE
*.AE1001
2.E-second main account
a.EA
*.EA1001

only ac1001,ac1002,Ea1001,ae1001 are only present in transaction table.

plz help me with the grouping in above mentioned way in data report and data environment in visual basic 6.0

Answer
from your description it is not clear about the design of your tables. if you are filtering on dates why not change the design of the table to include a year field?

in such cases i cannot give you a specific suggestion unless i see the design of tables and type of data.

for such work i expect to be paid

Ask a Question