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

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



More information about the AccessD mailing list