=Sum(Abs) and Date Range Question

[knowshowrosegrows]

In a report I have 2 simple text boxes. One is
=Sum(Abs([First_Level_Appeal_Determinations]="Denied")) and the other is
=Sum(Abs([First_Level_Appeal_Determinations]="Granted"))

Both are from the same field in the same table - no query involved. I want
the user to be able to input a date range and then run the report to count
the number of each criteria.

How would I do that?

 

[Stefan Hoffmann]

In a report I have 2 simple text boxes. One is
=Sum(Abs([First_Level_Appeal_Determinations]="Denied")) and the other is
=Sum(Abs([First_Level_Appeal_Determinations]="Granted"))

Using

=Sum([First_Level_Appeal_Determinations]="Granted")*(-1)

should be faster then using Abs().

Both are from the same field in the same table - no query involved. I want
the user to be able to input a date range and then run the report to count
the number of each criteria.

Use parameters in the query. Otherwise create a form to input the two
dates end refernce them in your query.


mfG
--> stefan <--

 

[knowshowrosegrows]

Thanks for your swift reply. This =Sum(Abs) is not is a query. The text
boxes are based on a table that has the [First_Level_Appeal_Determinations]
field and the date field. Are you saying I need to make a query with the
date range expession and make a subform and put that in the form where the
text boxes are?
--
Thanks

In a report I have 2 simple text boxes. One is
=Sum(Abs([First_Level_Appeal_Determinations]="Denied")) and the other is
=Sum(Abs([First_Level_Appeal_Determinations]="Granted"))

Using

=Sum([First_Level_Appeal_Determinations]="Granted")*(-1)

should be faster then using Abs().

Both are from the same field in the same table - no query involved. I want
the user to be able to input a date range and then run the report to count
the number of each criteria.

Use parameters in the query. Otherwise create a form to input the two
dates end refernce them in your query.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi,

Are you saying I need to make a query with the
date range expession and make a subform and put that in the form where the
text boxes are?

Yes.

mfG
--> stefan <--