Querry/Report...Multiple Criterion...Help!

[AMC31]

I have attached the file I am speaking of to hopefully explain what I am trying to accomplish.

I have a form [frmBroker] on this form there are 11 steps that are checked off as they occur. Begining with [FileStarted] and the last being [PrintBindSend]. We want to run a report that will show the current status of all clients that are not completed. Once a project has been "Printed, Bound and Sent" it is considered completed.

I need to create a querry and run a report and only show the last step or the step that is currently being worked on. Example: if we are waiting for Information to be received from the bank...then the field "Waiting for Info" would be checked and on the report I want to see the project name and "Waiting for Info"

Thank you for any help anyone can provide.

I hope this is possible...but I am stumped.

 

[Hayley Baxter]

I posted a sample in this thread that allows multiple searches from checkboxes.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=48476

HTH
Hay

 

[AMC31]

Thanks for the response...however I don' think that will give me the result I need. Maybe this will help

Example:
Project 1 is Waiting for Info
Project 2 has Finished the Report
Project 3 is Waiting to review Info.

I need a querry that looks to see what the status of each project is.

So...on the report I need to see
- Project 1 Waiting for Info
- Project 2 has Finished the Report
- Project 3 is Waiting to review Info.

Is it possible?

 

[AMC31]

Does anyone have any advice for this issue? Please...Thanks

 

[Jon K]

You can nest the 10 steps in reverse order in 10 IIF() functions in a query, i.e. beginning with FinishRpt and ending in FileStart (type/paste in the SQL View of a new query):-

SELECT tblBroker.RcdNo, tblBroker.ProjectName, tblBroker.ClientFName, tblBroker.ClientLName,
IIf([FinishRpt],"Finished Report", IIf([ReviewNarra],"Review Narrative",
IIf([WriteNarra],"Write Narrative",IIf([ReviewSpread],"Review Spreads",
IIf([WaitInfor],"Wait For Info", IIf([InitialSpread],"Initial Spread",
IIf([CallQues],"Calls/Questions", IIf([ReviewInfor],"Review Of Info",
IIf([CheckRcvd],"Check Received", IIf([FileStart],"File Started",
Null)))))))))) AS CurrentStatus
FROM tblBroker
WHERE Not PBS;