Making pending job query

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

HI,

I have a ActionTaken Table with fields JobID, ActionTaken, CurStatus. There
will be multiple entries for the same JobID till the job is complete.

How can I make a query to list all the records which are not complete?

Thanks

Ramesh
 
Ramesh,

I assume that if a job is complete, there will be an entry in this table
with a certain value in the CurStatus field? So, here's one way... make
a query based on this table, and in the criteria of the JobID field put
the equivalent of...
Not In(SELECT JobID FROM ActionTaken WHERE CurStatus="complete")
Then, make your query show Distinct records. To do this, right-click
anywhere on the background of the top panel of the query design window,
select Properties from the pop-up menu, and then set the Unique Values
property to Yes.
Run this query, and I think it will show a list of all incomplete JobIDs.
 
Ramesh said:
HI,

I have a ActionTaken Table with fields JobID, ActionTaken, CurStatus. There
will be multiple entries for the same JobID till the job is complete.

How can I make a query to list all the records which are not complete?

Thanks

Ramesh
Click to expand...
 
Back
Top