Entering Multiple Criteria in a Report

  • Thread starter Thread starter javab98
  • Start date Start date
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!
 
Is there any way that you could normalize your table structure? Each report
should create its own record for each grant. This would make reporting and
querying much easier.
 
Back
Top