Assign a null value?

G

Guest

I received this error msg on an append query. You tried to assign the null
value to a cvariable taht is not a variant data type.

Could this be from my conversion of -1 and 0 to y/n?

Please help!
 
G

Guest

Post your SQL.
What is the datatype of the field that has the "-1 and 0" you are converting?
What is the datatype of the field that you are converting to?
 

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

Null Value error in Append qry 9
Appendding to/from Upsize_ts (time stamp) field 3
Parameter queries and null values 2
Access 2002 Append Query Problems 1
Insert query with null column and null value 10
Append query getting null value error 3
Appending null data and moving! 4
How do I declare a variable as a Variant 4

Top