OMIT ARCHIVED RECORDS

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?
 
F

fredg

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"
 
Top