criteria for reporting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top