=Sum(Abs) and Date Range Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

knowshowrosegrows - 30 Mar 2007 15:46 GMT

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?

Signature

Thanks

Reply to this Message

Stefan Hoffmann - 30 Mar 2007 16:03 GMT

knowshowrosegrows schrieb:

> 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 <--

Reply to this Message

knowshowrosegrows - 30 Mar 2007 16:40 GMT

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?

Signature

Thanks

> knowshowrosegrows schrieb:
> > In a report I have 2 simple text boxes. One is
[quoted text clipped - 14 lines]
> mfG
> --> stefan <--

Reply to this Message

Stefan Hoffmann - 31 Mar 2007 11:28 GMT

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 <--

Reply to this Message