Same parameter / criteria requested multiple times

cft

Registered User.
Local time
Today, 03:56
Joined
Dec 31, 2001
Messages
52
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!
 

Users who are viewing this thread

Back
Top Bottom