Re: Expression typed incorrectly or too complex?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

My G_U_E_S_S is that Calculate_Working_Days is returning an error on one or more of the records. Probably because you are passing it a null value in one or more of its arguments and not handling that possibility in the function.

You might consider posting the function for review.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================


Allen Browne wrote:
This is a very general message that just means JET got stuck somewhere.

One cause is where the data types don't match. We don't know how your calculate_working_days() function is declared: what type of arguments does it take, and what type does it return? Does it accept variants, and return a variant? What happens if either of the aguments passed in is null? Is there a chance that JET could understand it as a non-numeric value, and therefore be unable to evaluate it against a numeric value (i.e. 10)?

.

Relevant Pages