I have created a client "report" in Access that prints the client information.
The client information records contain: "Document Name", "Document Date" and "Date Removed".
I want to give my client a detailed report of documents that are located in my office. Any document that has information in the "Date Removed" field, means the document is no longer in my office, and thus, I do not want it to appear on the report.
Prior to printing a detail line, I want the report to check the "Date Removed" field. If the field IS blank or null, then print the "Document Name" field, "Document Date" field on the detail line, otherwise, do not print the line.
Without using a query, I think I can build an expression (inside the reports "detail section") to exclude "Date Removed" records, but unsure how to do it.
I am using Microsoft Access 2002 version.
Thanks for your help.