Nicholson, Karen
cyx5 at cdc.gov
Thu Nov 18 11:43:29 CST 2004
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