How do I get totals of rows values in query?

A

Azad, DH, BD

I like to get result of net banlance from two tables opening balance and
Transfer.
What should be condition in query?

Opening Balance: Transfer:
MName OP Bl Qty Date MName Tr. Bl Qty
Date
====================== ======================
Bricks 5000 5/1/2008 Bricks 5000
5/1/2008
Cement 350 5/1/2008 Bricks 4000
5/1/2008
Bricks 5550 5/1/2008 Cement 50
5/1/2008



Net Balance:
MName OP Bl Qty Date
======================
Bricks 1550 5/1/2008
Cement 300 5/1/2008
 
J

Jeff Boyce

Azad

The <Subject> of your post indicates that you are trying to sum across
fields. This is what a spreadsheet does.

Access is a relational database, and expects data to be well-normalized.
Access sums "down", across records.

You could export what you've stored in Access to Excel to sum across...

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get Totals of rows values in query? 1
How do I get averages based on specific fields. 2
How can I put the value of a previous record field in a query? 2
How do I display 1 line per Invoice Summary w/totals from Invoice Detail ? 4
how do i get my query to do this 1
How do I convert row data to column data in Access design query 7
Values in crosstab represent change -- how to get query to return"current value" for each month? 1
How do I prevent Office from crashing? 5

Top