OMIT ARCHIVED RECORDS

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I am trying to run a report, but the report I have set up includes the
archived records. Can I change something in the report to removed the
archived records so they don't print?
 
I am trying to run a report, but the report I have set up includes the
archived records. Can I change something in the report to removed the
archived records so they don't print?
Click to expand...

What, in the record, indicates whether or not the record is archived?

If, for example, the record has an [Archived] field (a CheckBox), then
you could open the report, via a command button on a form, using:

DoCmd.OpenReport "ReportName", acViewPreview, , "[Archived] = -1"
 
Back
Top