Why error?

[smask]

Hi!

I finaly made it, almost!

Now I've got my correct sorting, but one problem remains.

I have a Query that sorts my indata. This quary is accessed by a report. In this report I'm trying to take [IN]-[OUT] but get the return; ERROR!

I did it like this:

=[SumAntalIN]-[SumAntalOut]

SumAntalIN is the sum over a group that consists of Product, Material and Color. Can it be the query that's faulty?

 

[bjackson]

is [sumantalin] a field in the query or is [antalin] the field

usually sum of looks like

=sum([in])-sum([out])

 

[Deborah]

This answer is probably way too simple but...
in my past experience I've noticed that if I don't have a value in every record (ie. 0 instead of null), I get an error message. Do you have numerical values in every record in the fields you're trying to sum?