criteria for reporting

S

SherriK

I need to generate a daily report that includes only information on records
with a field that falls outside a given range. I'm completely lost on how to
do this.
 
O

Ofer Cohen

Can you give an example to the filter you are trying to achieve?
Basically you need to use the WhereCondition of the OpenReport Command line

Dim MyWhereCondition as String
MyWhereCondition = "[FieldName] > #" & Date() & "#"
Docmd.OpenReport "ReportName" , , , MyWhereCondition
 
Top