[AccessD] SQL Float Type Conversion and Access

This one puzzles me. I have not experienced it before, so I just whipped up
a table to check this. I have a float field two of whose rows contain the
value 3. I did a query both from Query Analyst and Access (ADP) testing the
column for value 3 and I received two rows back in both cases. My FE was an
ADP, mind you. Is yours an MDB using an ODBC connection? I didn't try that.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen
Sent: August 5, 2005 10:09 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] SQL Float Type Conversion and Access

Happy Friday to all!  (Humor Day Reminder).  Anyway, I have an SQL
backend that has a few fields defined as float(ies).  When I do an
Access query against these floaties, and specify, for example the
criteria = 3, I get a message that my query is too complicated.  So, I
can either convert the SQL field to a better format that will preserve
the decimals, or I can figure out how to put criteria for a floatie in
Access.  I tried converting the field in SQL to numeric and it stripped
the decimal.  (backups are golden).  I don't want to go to nvarchar, I
am not sure I want to go to a double.  Any suggestions?  Thanks.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com