I have a form that displays data from different tables (for example, attendance records and phone monitoring scores). The parameter boxes are set to request the "Month as Digit" and "Employee ID". The problem I am encountering (in this and other forms/queries) is that the criteria is being requested multiple times to satisfy the requirements of the tables to pull the data. Once for Attendance, and again for Scores. I remember getting an error message while building these forms/queries stating that the same criteria was ambiguous and could be applied to either of the tables. Please advise how to format the SQL, or to set up the Join properties, etc. so that the criteria can be requested only once and applied to multiple sources. Thank you in advance for any help offered!

You will need to create a form with two text boxes which will be used to enter the parameters. The queries then need to be changed to refer to the form fields rather than prompting.