Report prompt for "ALL" or userid

[MBnewbie]

I have a report that prompts for the userid for selecting records for. I want them to either answer "ALL" and sort by userid or the individual userid that we want to select records for.

This is probably a no-brainer for most of you. But how do I modify the select statement to select according to the answer.

 

[snyperx3]

I guess you could build the select based on their response...i dont know how youre getting the response, but this is how you would build it if the response was stored in a variable (which ive named Response) :

"Select * FROM tblTable" & IIf(Response<>"All"," WHERE UserID = " & Response) & ";"

-Pete