weird sum on report

P

Pedro

Hi everyone
I'm building a report based on several crosstab qry and it seem ok with
values. That report has group values.
I want, at some point, a line with totals as well as a line with the
difference between 2 lines, like expenses to sales. Quite simple, i guess.
Result : not only it doesn't subtract in some grouping/levels, as well it
doesn't sum the other 4 lines i need.
Is this weird or not? (lol)
Tks in advance for all your help.
Pedro
 
D

Duane Hookom

Pedro,
I don't see anything wrong from where I sit. Of course, I can't see your
crosstabs, data, grouping levels, expressions, report setup, ... ;-)
 
P

Pedro

Duane,
Tks for your answer, but.
The problem it's fixed. Why?
In every objects i've put the =NZ and renamed all.
Then i "told" it to sum or subtract those fields.
Just for you to know.
Weird no?
Tks anyway
Pedro
 

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

Grouping a Report made with a cross tab qry 11
weird report result 2
Subtract on a report based on QRY cross table 14
Reports with Groupings 1
Reports with dates 2
Sum records if condition - on a report made with crosstab qry 0
Weird Report Footer 0
Grouping and Sorting a Report On Open Event 5

Top