Show only data that matches criteria and previous

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.
 
K

KARL DEWEY

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drag and Drop field onto calendar 0
1 Report, 3 Subreports, 3 Sources, Criteria Selection 0
Trying to show status by changing color of city on a map. 1
Conditional Formatting, Criteria from a Table 1
query to show where no data in a stated column 0
Query to show details of dataset when one type of data is still blank 1
only showing Switchboard on startup 5
Marking Col. A if number matches 0

Top