SQL statement

S

stevecrowhurst

Can anybody explain why I should get a data mismatch error
when writing an SQL statment for a querydef
 
M

Marshall Barton

Can anybody explain why I should get a data mismatch error
when writing an SQL statment for a querydef
Click to expand...


Someone might be able to do that, but not without seeing the
SQL you're trying to use.

A common issue that causes that message is trying to place
text in a numeric or date field, but I have no idea if
that's your problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Creating a querydef of a stored proc on Sql Server 8
Page numbering with Merged Document and IF statements 1
Creating a select query using sql in VBA 6
Multiple If Then Statements Stored In table 9
SQL statement in VBA 4
Can I save a sql statement generated by a search form? 1
PivotTable: Type Mismatch 0

Top