Recent Request

[tryn2learn]

Good afternoon,

I am trying to get my database to show only open or work in progress status
items.
when this request are first submitted the person sending fills out the date,
their name and reason for request.

once i get the email that a new request has been submitted i go into the
database to assing a tech to the request... the problem is when i go into the
database to complete the rest of the submitted form i have to scroll through
everthing that's out there to find the one that was just submitted.... is
there a way to make only open request that are not assigned come up instead
of all reqeust?

currently the query i'm using to open and then complete the form has this
code:
SELECT TOP 1 Tech_Req.*
FROM Tech_Req
ORDER BY Tech_Req.Date_Req DESC;

i hope this makes sense... thank you for your help.

 

[KARL DEWEY]

Try this assuming you have a Status and an Assigned field --
SELECT Tech_Req.*
FROM Tech_Req
WHERE Tech_Req.Aasigned Is Null OR Tech_Req.Status <>"Closed"
ORDER BY Tech_Req.Date_Req DESC;

 

[tryn2learn]

That's just want i needed... thank you very much.

I hope you have a great weekend.