Nicholson, Karen
cyx5 at cdc.gov
Fri Aug 5 10:05:12 CDT 2005
Yes, mine is an mdb with odbc. I have it solved now - I changed the SQL type to numeric with the scale set to 1. Now it is OK. Access totally puked on querying a float. Now, I sure wish I could figure out why the Access 2003 PCs around here are locking out the report area of the databases. Even simple code to open up the report croak. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Friday, August 05, 2005 10:58 AM To: 'Access Developers discussion and problem solving' Subject: RE: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com