Kaup, Chester A
kaupca at chevrontexaco.com
Thu Nov 18 12:56:25 CST 2004
I had to use the csng function on each field in the second query. I was just wondering if this is normal behavior for access or if something else is happening. Chester Kaup Information Management Technician IT-MidContinent/MidContinent Business Unit CTN 8-687-7415 Outside 432-687-7415 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen Sent: Thursday, November 18, 2004 11:43 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Query of query results problem Isn't there something about a calculation inheriting the format of the, what I think of, the simplest format? What if you set the formatting in the second query in the query itself to like a double and specify the number of decimals? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester A Sent: Thursday, November 18, 2004 12:23 PM To: accessd at databaseadvisors.com Subject: [AccessD] Query of query results problem I have a query with no formatting in it that generates numbers with various numbers of digits after the decimal place. When I run a query against this query with no number formatting the result in integers (all decimal precision is gone). What is happening here? Chester Kaup Information Management Technician IT-MidContinent/MidContinent Business Unit CTN 8-687-7415 Outside 432-687-7415 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- _______________________________________________ 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