Grand totals error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tu - 14 Oct 2005 05:59 GMT

Hi,
I create an Access Report called "Daily Driver Board" listing all the
deliveries to be made by our trucks. The datas are grouped and summarized
first by truck, then vendor, then by ship-to address. I have two separate set
of amounts to be tabulated, first by truck, then in Grand totals: COD and
regular charged amounts. The two amounts are added to a Daily Total by Truck
and Grand Total for all the trucks.
The Daily Total (COD+CHG) for the trucks are correct. But the bottom Grand
Total (COD+CHG) is wrong: somehow it picks up the Daily Total (COD+CHG) of
the truck right above it.
Please help figure out what happens, did I do something wrong?
Thanks.
TTN

Reply to this Message

Jeff Boyce - 14 Oct 2005 13:28 GMT

You didn't mention the section/band in which your GrandTotal calculation was
done.

I didn't notice your calculation using the Nz() function, to handle any
nulls.

Signature

More info, please ...

Jeff Boyce
<Access MVP>

> Hi,
> I create an Access Report called "Daily Driver Board" listing all the
[quoted text clipped - 9 lines]
> Thanks.
> TTN

Reply to this Message

Tu - 15 Oct 2005 06:03 GMT

Hi Jeff,
Thank you for your very prompt reply. This morning I did solve the problem
by chance. I believe the problem occured when I was coying the Sum[CODAmt] &
Sum[CHGAmt] back and forth while resizing my form. I erased and re-entered
the Sum expression inside the Control Source and it's working fine now.
Regarding the Nz( ) Function, I will learn and try to use it; I was using
the IIf function instead 8-(
If you allow me, I do have another question: still regarding the Driver
Board. Inside the "Truck #1" Group, there are sub-groups of "Account" then
sub-sub-groups of "Ship-to address". For example in the "Truck#1" group, I
have 15 stops sorted by Account then by Ship-to-address. If the Shipping
manager wants to change the Delivery route for the truck, is it any simple
way to re-sort within the same truck?
Thanks!!
Tu

> Hi,
> I create an Access Report called "Daily Driver Board" listing all the
[quoted text clipped - 9 lines]
> Thanks.
> TTN

Reply to this Message

Jeff Boyce - 15 Oct 2005 13:47 GMT

Re: your additional question

Since this is off the original topic, and since it appears you are asking a
"Report"-related question, I'd suggesting posting the new question in the
access.reports newsgroup, where you'd be more likely to catch more eyes.

My first reaction is that I don't understand how a change of order (via a
form) is NOT being reflected in your report.

Regards

Jeff Boyce
<Office/Access MVP>

> Hi Jeff,
> Thank you for your very prompt reply. This morning I did solve the problem
[quoted text clipped - 25 lines]
> > Thanks.
> > TTN

Reply to this Message