2 conditions for query based on user input on form
Posted on 2013-11-02
I have a report based on the following querry:
SELECT tMain.FrameLine, tMain.FrameModel, Count(tMain.FrameModel) AS CountOfFrameModel, tMain.FrameOWF, tMain.Office
GROUP BY tMain.FrameLine, tMain.FrameModel, tMain.FrameOWF, tMain.Office, tMain.Status
HAVING (((tMain.FrameLine)=[Forms]![FReportSelect]![cFrameLine]) AND ((tMain.FrameOWF)=False) AND ((tMain.Office)=[Forms]![FReportSelect]![LocSelect]) AND ((tMain.Status)<>"Cancelled"))
ORDER BY tMain.FrameModel;
I would like to update the query based on [Forms]![FReportSelect]![LocSelect]. as it can either have an acutal office selection OR "All" (for all locations).
Presently it is working for a selected location but I can't find a way to have it work for "All offices.