Correct syntax for report
Posted on 2013-11-02
I have a report with a solution from EE..... which is working great (Thanks!)
In the working report I have a text box with the control source as:
=[CountOfFrameModel]/DCount("FrameModel","tmain","frameLine='" & [FrameLine] & "'and tMain.FrameOWF = False and tMain.Status <> 'Cancelled'")
I would also like to add anothe criteria based on a form selection but can't find the syntax.... The form is [Form]![fReportSelect]![LocSelect]
The only catch is that there are 3 locations possible and "ALL"
So while I would like to add the "locseelct" to the text box's control source but also keep as it is above when "All" is selected from the locselect on the form.
Is this possible? If I could get the syntax correct I thought perhaps of using an IF statement in the control box.