Trying to join a table in access to a crystal SQL command 1

[jerrylj]

I am trying to join an access table with the key field being a currency field to an SQL command with the key field being in currency also. I am using ODBC to bridge the two. The error I get is that the "DATA TYPES ARE NOT COMPATIBLE" I do a browse field on the access field ond it says number. I browse the SQL field and it says Currency. I have tried everything I can think of in Access to make the field a currency field. Does ODBC change somehow? Thanks

 

[jerrylj]

sorry I forgot to say I am using Crystal 10.

 

[SBendBuckeye]

Not in Crystal, but I had that issue between SQL Server and Access once because they define things slightly differently. Try using one of the explicit type casting functions such as CDbl to see if that helps you. Good Luck!

Have a great day!

j2consulting@yahoo.com

 

[synapsevampire]

You also forgot to say what database you're using other than Access.

Consider simplifying the model and your life by creating the SQL using Linked Tables (not imported) from within the MS Access database and then just creating a Access query to use for the report data source.

Crystal is slower than Access at connecting disparate data, and your current model seperates the data access between 2 tools, increasing the likelihood of failures (such as this) and complicating maintenance.

-k

 

[jerrylj]

I am pulling from Sybase using ODBC.