Let, i have a msàccess db with 3 tables having 'cost' field in all of them . Now in my report i want to
1) Show the sum of costs of indivisual table under the heading of each table (let $3000 for every table) &
2) show the sum of all the sum value of individual tables (here it would be $9000) at the bottom of the page under 'total' heading. How can i do it? Plz help me.
shahriar2403 0 Light Poster
ryan_vietnow 13 Posting Pro
Use LEFT JOIN command in your SQL Query to combine all the 3 tables.
debasisdas 580 Posting Genius Featured Poster
Use suitable joins to retrive data from multiple tables.
shahriar2403 0 Light Poster
Would you plz kindly give some coding with example. Actually i am new in it. If da example is close to my problem that would be very much appreciable...
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.