Recent content by ClintonHolder

Thanks Les, Before this I didn't know how you could stack the criteria, your solution works perfectly! You saved me many hours of trial and error! Thanks again!

Thanks Les, The query looks like it works by itself but for some reason the text box's control source that runs the query in the expression just returns #ERROR Any ideas why? =DSum("Points","qryTardy","EmployeeID = " & [txtEmployeeID])Is it because the DSum has no idea if the txtEmployeeID is...

I have a points based attendance database that I am trying to enhance with different rules based on if the employee is part time or full time, for instance I am trying to Dsum their points from all occurrences within the last 365 days but if now I am trying to create some sort of IF the...