[AccessD] Report Troubles

SUM(BOPD) works.
Format problem somehow fixed itself.

Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, April 03, 2008 12:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Report Troubles



> The first problem is that when I go to set the format for a text box
the
> drop down list is empty. The report also ignores the format settings.

========I don't have an explanation for this one.
>
> Second problem. I put the following as the control source for a text
box
> in the report footer and it returns a value of #error#.
>
> =Sum([qry Estimated MTD Oil Sales by Manifold]!BOPD)
>
> This is the query the report is based on.

========Remove the query reference -- SUM(BOPD) is all you need, as long
as 
BOPD is in the underlying data source.

Susan H. 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com