I have the following query that is subtracting two fields based on date criteria. I am getting a data type mismatch error. Can you please advise how to correct this error.
Subtraction: DSum("[Number of Personnel Assigned] - [Number of Personnel Attended]","Query By Month","[Date of Meeting] >='4/1/2004' and [Date of Meeting] <='4/30/2004'")
Thanks is advance for your assistance!