I am getting a strange error message on my report, "Data type mismatch in criteria." It occurs when I attempt to preview my report. I understand what it means, but I don't know where this error is occuring. I have stepped through my code in Report_Open, but the error occurs after my code has been executed.
I have a feeling what the error might be from. I have a field in my query which is for the most part a date field. In my query I check to see if it is a certain date, if so, I make the field equal to "", which essentially converts it to a string value, not a date value.
Can anyone help me find where I am having this issue in my report? Thanks!
I have a feeling what the error might be from. I have a field in my query which is for the most part a date field. In my query I check to see if it is a certain date, if so, I make the field equal to "", which essentially converts it to a string value, not a date value.
Can anyone help me find where I am having this issue in my report? Thanks!
