Unbound Control Filtering

[TechNat]

Is there anyway to filter a unbound control within a report?

I have a unbound control with an IIF statment to determine the total hours per employee on that report. The only problem is that I need to filter the record if the hours are 80 and above.

There are a few other variables that make up to the 80 hours, such as holiday, vacation, and sick pay. Regular pay is added with the other variables to get to the 80.

I need to take the Total Hours from the Report and use that to filter the query. Is there anyway to do this?

 

[boblarson]

Put the calculation into the report's underlying query instead of on the report itself. Then it will become a field that you can filter by.

 

[TechNat]

Thanks for the help, but I already tried that. I am getting some errors when trying this within the query.

Here is the expression that I am using

=IIf([CheckDate]=[CheckDate],Sum([HoursReceiptAmtWages]))

When I run the query, I get an error,

"You tried to execute a query that does not include the specified expression 'Dept' as part of an aggregate function."

I have all my tables linked, but no luck.

Any ideas?

 

[georgedwilkinson]

This error has very little to do with the Iif statement. You need to put Dept in your group by clause (and possibly some other columns).

Do you realize your Iif statement will always evaluate to true? Thus, it is not required and you can just use the Sum.