Show only data that matches criteria and previous

  • Thread starter Thread starter NeoFax
  • Start date Start date
N

NeoFax

I have a report that currently shows all open jobs broken down by
helicopter and stage of work being accomplished. I have a table that
is updated to show the progress of the helicopter thru its stages and
the helicopter is the primary key. What I would like to be able to do
is if the helicopter is in stage 3STA, I would like to see Stages
0STA, 1STA, 2STA and 3STA but not 4FL, 5Paint ... I do not know how
to set the criteria to show this.
 
What do you enter to show a stage is complete? If it is a date of completion
then use Is Not Null as criteria in that date field. If you change status
from 'Not Working' to 'Working' then use criteria <>"Not Working".
 
Back
Top