Expand|Select|Wrap|Line Numbers
- WHERE (((AccDS1check) Is Not Null) AND ((AccFabDate)=GetFDate()) AND ((AccRelacion)=21))
Expand|Select|Wrap|Line Numbers
- Public Function GetFabDate () As String
- GetFabDate = ">#01/01/1980# and < #01/01/2011#”
- End Function
Error 3464: mismatch in criteria expression. The criteria expression in a Find method is attempting to compare a field with a value whose data type does not match the field’s data type.
Can anyone help? I need to be able to change the query value dynamically and have code to calculate the string values in the public function