Recent content by mhark

Cross5900 - i read your post on how your comany uses the Environ formula and the user table along with the dlookup to limit sercurities. could you provide me with more information on to set this up or can you send me a sample database with this logic

Got it. Thanks

All, when I run the following code in my query I get the below error, any ideas? SQL Code SELECT AttendancebyDate.Date, AttendancebyDate.EmployeeID, AttendancebyDate.Duration, [Time&LaborArchive].OccuranceNeeded, [Time&LaborArchive].OccuranceAcknoledged FROM ([Time&LaborArchive] INNER...