Totaling in a Report

  • Thread starter Thread starter cevans36
  • Start date Start date
C

cevans36

I have linked my table with a spreadsheet in excel. In creating a report I
have grouplings. Within these groupings I am trying to get totals in two
columns. In layout view (Office 2007) I used the =Sum([Amount]) in the group
footer. It is totaling, but it is wrong. I tried to do a count and it is
also counting wrong. Talk about crazy...This has to be completely simple,
but I am unable to get it to work.

Any help I would greatly appreciate!

Thank you!

Christine
 
Cevans36,

Totaling wrong and counting wrong is kinda vague... Would that be that it's
returning more records than you want or less records? When you open your
linked spreadsheet do you see anything that would give you the wrong count
and total?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
I had a similar issue when I converted my excel into access it dropped
fields in some records. and not the same field and not in the same record. I
created a report in access with all fields and i imported 1 section at a time
so I could see what it was losing. When I did 50 records at a time it worked
except on the beginning of the file. access dropped/lost the first 3 records
and then the 1 in the middle. Im thinking since the 1st 3 records did not
have data in each field it went to the 1st one that had data in all the fields
 
Back
Top