Reports with filters

[jbs]

Hi,

I'm trying to design a report that only shows items from a table that meet a certain criteria.

On the table I have two columns, one for date entered and another for date exited and I'm after a report that will only show items where the difference between date entered and date exited is greater than 4 days.

Is this possible and any idea on how this is done? (please excuse my noviceness)

Thanks.

 

[Alansidman]

jbs;
Build a query and set the parameters in the query criteria. Use the query as your record source for your report instead of trying to run the report directly from the table.

Alternatively, you could use this approach:

http://www.datapigtechnologies.com/flashfiles/passparamtoreport.html

Personally, I prefer the query method.

 

[jbs]

Thanks for the suggestion,

I have changed my criterea slighty, I want it to be able to filter based on the number of days that have passed since date entered and if a checkbox has been checked. Is this possible and what code would i put in the critirea section on the query design view??

thanks

 

[Alansidman]

You will need to create a new field in your query and place an expression in it that is something similiar to =IIF(date()-yourfieldname >= some value, "Yes","No"). Then filter on the yeses. And filter also on the field having the check box.

Alan

 

[jbs]

Thanks again.

Ok I have entered this code in a new field on my query

Expr1: IIf(Date()-" «Expr» [Table1]![OpenDate] «Expr» ">=5,"Yes","No")

but when i go to exit design view i get "Data type mismatch in criteria expression"?

The criteria box for all are blank

 

[Alansidman]

Remove the <<Expr>> from the expression.