Search results

I'm not sure I get this code entirely docmd.OpenReport "",,,"UserName='" & me.username & "' AND OrderType='" & me.OC01 & "'" What is the ",,," supposed to be? Also, the "UserName=" makes me believe that I'd have to input that username everytime I want to check, and I want it automatically. I...

Hi, I cannot currently post a screenprint of that since it is the weekend and I don't have the files at hand. When I say amount I mean this, for example, we have these order types: OC01, OC02, OC03 (there are more, but keeping it simple). The amount I mean is, X employee created 25 OC01 orders...

Is this even possible? Let me talk you through this scenario. I have three tables. TableA contains certain order information, such as the username of the employee, type of order, alias number, etc. TableB contains phone numbers, username of the employee, etc. TableC contains supervisor...