Mike and Doris Manning
mikedorism at ntelos.net
Tue Jul 1 17:45:50 CDT 2003
Check your query... Access probably stuck Expr1 in for the name instead of BillingAmount. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Tucker Sent: Tuesday, July 01, 2003 4:48 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Converting a string to a double in an SQL query. Thanks for the reply. That did what I was looking for. However, I'm seeing another problem when basing a report off of this query. I am seeing the following error message when trying to preview the report I am creating... "Column (BillingAmount) was used in a CALC expression but is not defined in a rowset." I'm not really doing anything fancy except trying to sum the new "Billing" field which is =Convert(money, dbo.Transactions.BillingAmount). In fact, I get the error message even when I take the "Billing" field off of the report. Anyone know what may cause the error message? Thank you. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike and Doris Manning Sent: Tuesday, July 01, 2003 2:59 PM To: 'Access Developers discussion and problem solving' Convert(money, dbo.Transactions.BillingAmount) Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Tucker Sent: Tuesday, July 01, 2003 1:17 PM To: AccessD at databaseadvisors.com Subject: [AccessD] Converting a string to a double in an SQL query. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com