Simple SUM

[smask]

Hi!

I'm trying to make a small report of inventory.

[Article] [Color] [Height] [In stock]
___ g_____ r_______t________3
__________________y________2
___________________________5
___________________________2
___ a_____ y_______t________3


etc.

In the "In stock" I've got "in" and "out" and wants to take
"in" -"out", but I can't make it work ( the sum of "in" and "out" is displayed in "In stock").

I've tried:

Sum([in]-[out]) but this gives the sum in "all fields".

Further all numbers are shown in the table, not just the total sum of an article of a sertain color and heigt. Every entry is shown seperatly.

Want to make it like this =>

[Article] [Color] [Height] [In stock]
___ g_____ r_______t________3
__________________y________9 <----------
___ a_____ y_______t________3

Need all help I can get!

/ Smask

 

[guldo76]

Well, I think you can:
1. build a grouped report, and perform group totals (but maybe it would overshoot your goal)
2. build a query with totals, and use it as source for the report
3. write the sql statement of the query directly as source for the report, so that you don't have to create any query
The 3rd is the best.
You can pretend to create a query in order just to get a right sql statement; anyway it'd look like
select field1, sum(field2) as whatever
from table1
group by field1;

Bye,
Guldo

 

[smask]

Thanks, but I'm to slow to get it.
I've made a groupe based report, but my prob is still there!

[1]
_____[2]
____________[3]
_____________________[Here I want the sum of IN - OUT if 1,2 and 3 are meet]

I use "if same hide" but i doesn't work with the numbers, so I get numbers for all data that's been entered.

Further the sum is not working.

Since I'm a complete beginner I need the tips more "general"

 

[Glennzo]

Sum

How about leaving out the word "sum" ???

=[in]-[out]

Would that work ???