Error message 3464

[1starr]

This is the error message I keep getting when I run my query: 3464: Data type mismatch in criteria expression. If anyone knows what this means please let me know.
Thank You.

 

[mpastore]

Usually it means that you are trying to join fields that are diffeent data types (e.g. date vs. text) or that some critreia of your query for a field is the wrong type (e.g. you specify a text parameter for a date data type).

Post SQL to this forum if you are still having problems.

Mike Pastore

Hats off to (Roy) Harper

 

[1starr]

Thanks!!!!