Incompatible Data types form Access to SQL Server 7

[DougP]

I have data being saved into a SQL server table from UPS World Ship through a DSN.
I can see the data just fine in Access. When I try to look up something using the Job number field from SQL Server I get a type mismatch in my VBA code window

The data is "nvarchar" in SQL. Can I convert it or what’s up with this. I need th edata to be variable in SQL I choose this fireld becasu the "char" data type padded the data with trailing spaces which creates other problems.

here is my VBA code:

SQLHead = "SELECT SALES_ORDER, ORDER_TYPE, CUSTOMER, CUSTOMER_PO_NUM FROM [none_SO_MASTER_HDR] WHERE SALES_ORDER = '" & ordernum & "';"
Set Head = db.OpenRecordset(SQLHead) '<<< Error here 'type mismatch'

TIA
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[tlbroadbent]

Are all of the fields in the query of data type nvarchar?

You can try a conversion such as

WHERE cast(SALES_ORDER As nvarchar) = '&quot; & ordernum & &quot;'&quot;

However, I'm not certain that really addresses the problem.
Terry

http://members.home.net/tlbroadbent/index.htm

 

[DougP]

I fixed it
I had another issue which was masking as that.
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive