Search results

It would but that field is a dropdown with about 10 options, I just want to calculate each lookup value in the combo box, this also needs to be done in the form as a control source, or it will not work and update as needed.

Hello, I just realized I made an error =CDbl(Nz(DSum("[Number of Days]","[Employee Attendance Extended]","[TypeofLeave/Exception]" = 'Sick' "))) .............................................^ is a field........................^ is the query.......................................^ is the...

=CDbl(Nz(DSum("[Number of Days]","Employee Attendance Extended","[Sick] = 'string' "))) doesn't work and =DSum("[Number of Days]","Employee Attendance Extended","[Sick] = 'string' ") doesn't work Maybe I am misunderstanding? {#of Days is the field, Employee Attendance Extended is the query...

Hello, I am not sure how to use this function, and how to make that target only the entries that have "Sick" as the data... Is there anyway you could give me an example to try by chance? Thanks!

Hello, I am creating an employee database, and am working on tracking attendance. Below is a working code to count all occurrences no matter what type of category (sick, emergency, etc.) =CDbl(Nz(Sum([Number of Days]),0)) I am struggling with making a code that references the "Number of Days"...