Grand totals error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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>

Tu said:
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

Tu said:
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
Click to expand...
Click to expand...
 
Back
Top