calculations in my report


G

Guest

I have a report that i want to show the total cost and then the balance
due.... I have the calcs in the report as =sum[total cost formula] and the
same for balance due the problem is that when the report comes up the first
calc shows an addition of all my records what should be
customer id 1 total 400.00 bal due 150.00
customer id 2 total 300.00 bal due 0.00
customer id 3 total 175.00 bal due 75.00

i am getting
customer id 1 total 875.00 bal due 225.00
.............................. 1750.00 450.00
.............................. 2625.00 675.00

any ideas how to fix this. thanks all!
 
Ad

Advertisements

L

Larry Linson

Yes, I am certain that you can fix it if you assure that your data is
correct, that you have used an appropriate query, and done your report
properly. As you haven't described in detail any of those items, more
specific suggestions are not possible. If you would provide the detail,
perhaps someone might be able to offer more than a broad, generic
speculation.

Larry Linson
Microsoft Access MVP
 
G

Guest

Hi,

Not a lot of info but I think I know where you going. If you are looking to
separate your totals, set your report up with a group header and footer. In
the header place the field Customer ID or what ever the field is that you are
reprsenting and in the footer place your calculation there for the Total and
Balance due. I am guessing you have the calculation in the report footer
which is going to give you a grand total of everything on the report.

Hope this helps!!
 
G

Guest

i didnt use a query.... the results are from useing the formula =sum[stuff
from my form]+[the other stuff] right in the report control source field....
i tryed to use a query but i cant seem to get the query results into my
report. a detailed instruction on how to enter the query into the field
would be great!!

Larry Linson said:
Yes, I am certain that you can fix it if you assure that your data is
correct, that you have used an appropriate query, and done your report
properly. As you haven't described in detail any of those items, more
specific suggestions are not possible. If you would provide the detail,
perhaps someone might be able to offer more than a broad, generic
speculation.

Larry Linson
Microsoft Access MVP

datahunter said:
I have a report that i want to show the total cost and then the balance
due.... I have the calcs in the report as =sum[total cost formula] and the
same for balance due the problem is that when the report comes up the
first
calc shows an addition of all my records what should be
customer id 1 total 400.00 bal due 150.00
customer id 2 total 300.00 bal due 0.00
customer id 3 total 175.00 bal due 75.00

i am getting
customer id 1 total 875.00 bal due 225.00
............................. 1750.00 450.00
............................. 2625.00 675.00

any ideas how to fix this. thanks all!
 
Ad

Advertisements

L

Larry Linson

With due respect, I recommend that you spend some quality time with a good
self-study or with the online training you can access from
http://office.microsoft.com. An inexpensive, but good self-study book for
the raw novice is Microsoft Access <version number> Step by Step; a book
that starts at the beginning but delves deeper is Microsoft Access <version
number> Inside Out, both from Microsoft Press.

Reports are for presenting data from Queries and Tables. You can "jump
through some hoops" and use other data, but that is not the basic intent of
Reports.

Larry Linson
Microsoft Access MVP


datahunter said:
i didnt use a query.... the results are from useing the formula =sum[stuff
from my form]+[the other stuff] right in the report control source
field....
i tryed to use a query but i cant seem to get the query results into my
report. a detailed instruction on how to enter the query into the field
would be great!!

Larry Linson said:
Yes, I am certain that you can fix it if you assure that your data is
correct, that you have used an appropriate query, and done your report
properly. As you haven't described in detail any of those items, more
specific suggestions are not possible. If you would provide the detail,
perhaps someone might be able to offer more than a broad, generic
speculation.

Larry Linson
Microsoft Access MVP

datahunter said:
I have a report that i want to show the total cost and then the balance
due.... I have the calcs in the report as =sum[total cost formula] and
the
same for balance due the problem is that when the report comes up the
first
calc shows an addition of all my records what should be
customer id 1 total 400.00 bal due 150.00
customer id 2 total 300.00 bal due 0.00
customer id 3 total 175.00 bal due 75.00

i am getting
customer id 1 total 875.00 bal due 225.00
............................. 1750.00 450.00
............................. 2625.00 675.00

any ideas how to fix this. thanks all!
 

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


Top