
October 23rd, 2002, 06:31 AM
|
 |
Big Endian
|
|
Join Date: May 2001
Location: Fly-over country
|
|
Quote: | Wrong data type (integer instead of text)? |
This is most likely your problem. In your SET or WHERE clause, you have something like numeric field = string variable. Also, if your query has any date variables in these clauses, you might have to delimit them with a # at the beginning and end of the date so that Access will cast it properly (EntryDate = #10/22/02#)
If you can't solve the problem, it would help if you post the SQL you're running. Its hard to solve a programming problem without seeing the code.
|