Report Problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Steve M
    #1

    Report Problem

    I need help getting a report to do what I want.

    I have an archive table that contains the date, day of week, different
    types of work and the arrival time for each type of work. I also have
    2 columns in another table for the time each type of work was due (as
    opposed to when it actually arrived). One column is for Monday through
    Thursday, the other for Friday because work is due later on Fridays.

    When I open the report I want to key in the date and have the report
    show only the work that was at least 10 minutes late on that date. The
    report works well except that I don't know how to get it to choose to
    calculate the late arrivals on either the M-Th or Fri. due times based
    on the day of the week. I can get it to always use the M-Th due times
    or always use the Fri. due times to calculate which work was late but
    I can't get it to choose between them. I have tried different criteria
    in the query the report is based on and also different expressions in
    the control source in the report itself. So far nothing has worked.

    I will appreciate any and all suggestions.

    Thanks
    Tags: None
    • Pieter Linden
      #2
      Re: Report Problem

      stevem@crprod.c om (Steve M) wrote in message news:<dea080df. 0406282314.335e c7dd@posting.go ogle.com>...[color=blue]
      > I need help getting a report to do what I want.
      >
      > I have an archive table that contains the date, day of week, different
      > types of work and the arrival time for each type of work. I also have
      > 2 columns in another table for the time each type of work was due (as
      > opposed to when it actually arrived). One column is for Monday through
      > Thursday, the other for Friday because work is due later on Fridays.
      >
      > When I open the report I want to key in the date and have the report
      > show only the work that was at least 10 minutes late on that date. The
      > report works well except that I don't know how to get it to choose to
      > calculate the late arrivals on either the M-Th or Fri. due times based
      > on the day of the week. I can get it to always use the M-Th due times
      > or always use the Fri. due times to calculate which work was late but
      > I can't get it to choose between them. I have tried different criteria
      > in the query the report is based on and also different expressions in
      > the control source in the report itself. So far nothing has worked.
      >
      > I will appreciate any and all suggestions.
      >
      > Thanks[/color]

      Where to begin?
      If you want to enter a date and limit the records to it, you could
      base the report on a parameter query that prompted for a single date.
      If you have different rules for lateness for M-Th and Friday, then you
      need to incorporate that logic into the query on which you would base
      your report. Play with IIF and see what that does for you.

        Comment

        Previous template Next
        Working...