[AccessD] Converting a string to a double in an SQL query.

Michael Tucker mtucker at myrealbox.com
Tue Jul 1 15:47:38 CDT 2003


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.



More information about the AccessD mailing list