Collect certain values

[azhar2006]

Hello all
How I do I collect the amounts that fall between brackets in the report
In other words, only debt
-100

[JoeM]

Create a query, and use the following criteria under that field:

< 0

That will only return records which have values less than zero in that field (your debts).

[JoeM]

Reply in PM:

Thank you very much
Your answer to my question was
Create a query, and use the following criteria under that field:
How do I do this in the report
Is it possible example

You should make all your replies back to the thread, not via Private Message.

Simply base your Report on the Query instead of the Table directly.
Pretty much anything you can use Tables for you can use Queries for (Reports, Forms, data exports, etc).

[azhar2006]

I worked so
That's where the report goes back to the query
But there is a problem at the end of the report writing function

[ItsMe]

You can create detail footers in reports. If you right click the "Detail" control in the report, you can select an option to include headers and footers for the various sections of the report.

You can place an unbound control in the detail footer, or header, and then type your expression inside the control. Maybe something like...

= Sum(NameOfField)

[azhar2006]

Thank you itsme
I just want to collect the values ​​that hold value -

[June7]

Try:

= Sum(IIf([fieldname]<0,[fieldname],0))

[azhar2006]

yaaaaaaaaahooooo
Thank you very much June