Search results

  1. C

    Running different queries within expression based on field value

    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!
  2. C

    Running different queries within expression based on field value

    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...
  3. C

    Running different queries within expression based on field value

    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...
Back
Top Bottom