Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    Alaska, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi-criteria Report (2003)

    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 together in one.

    Any help that can be provided would be greatly appreciated!

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Multi-criteria Report (2003)

    One approach would be to add 7 calculated fields to the query that drives the report.
    One field for each report, then display these fields on the Report.

    Report1Status: IIf([fldreport1Rvd]=True,"Received",IIf([fldReport1Due]<Date(),"Not Due Yet","Overdue"))
    Repeat for each report.
    Regards
    John



  3. #3
    New Lounger
    Join Date
    Jan 2004
    Location
    Alaska, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-criteria Report (2003)

    That worked!!! Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •