View Single Post
  #17 (permalink)  
Old May 23rd, 2011, 04:58 AM
disel2010 disel2010 is offline
Authorized User
Points: 448, Level: 7
Points: 448, Level: 7 Points: 448, Level: 7 Points: 448, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2011
Posts: 86
Thanks: 1
Thanked 12 Times in 12 Posts
Default

Hi,

it looks like there is some invalid data in your database.

If I'm not mistaken line 113 is this line:
Code:
 ProfitLoss = AuditFees - OverallHourCharge
The error indicates a type mismatch, probably you are trying arithmetics with a string here... (Type mismatch: '[string: "600 interim"])

My guess is that in your field JobFees.adut_fees you somewhere have this string (See also line 68: AuditFees = pwcoRecordset4("audit_fees"))

I hope this helps.