Entering Multiple Criteria in an Access Report

J

javab98

The main purpose of the report that I need to create is to advise
project leaders on which reports, that are required by a grantee, are
over due.

For every grant there are seven reports that are due at different
times throughout the grant period. In my table I have two fields for
each report: fldReport1Due (date format)this is the date the report is
due and fldReport1Rvd (yes/no), if it is checked then we have received
the report if it is not checked we have not.

On the report I have listed the following fields:

fldGrantNum
fldGrantee
fldProjectName
fldReport1Due
fldReport1Rvd
fldReport2Due
fldReportRvd
..
..
..
fldReport7Due
fldReportRvd

All of the fields listed above are currently in one table called
tblData.

I want to be able to print a report that lists the first three fields
then some how "highlights" or lists those reports that have a due date
that is prior to the current date AND the corresponding checkbox is
unchecked, all on one report, for each grant. I know how to make this
work on seven different reports, but not all grouped togehter in one.

Any help that can be provided would be greatly appreciated!
 
Top