Selection Criteria acts as a filter which only allows certain types of records to be included in the report. While an experienced user can usually re-write a record source query each time the report is run to allow this flexibility, this is not easily done by a beginner. Potomac s approach is to create code which allows users to fill in a selection criteria screen each time a report is run. During the design phase, we discuss with users which fields should be available for limiting the records included in a report. Using this information, we design a screen that allows users to place as many or as few limits on a report as they desire and to change these limits every time a report is run.
Reports are the easiest and most effective way to present data in a printed format.
They can be as simple as basic mailing labels or can be dressed up to include company logos, special formatting and assorted totals and subtotals. Whether the report layout is simple or complex, the report itself is only useful if it can be made to display all of the data desired and only the data desired. Getting What You Need , Access Datatypes .