Report expression builder parameter value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve-in-austin - 17 Jan 2006 17:18 GMT

I have an expression to sum three values from a linked (to Excel) table. The
expression was built with expression builder but the reports prompts for
"enter parameter value" with a reference to the table name "CO 2005-11-30".
Why?
Formula:
=[CO 2005-11-30]![Acres-Original Residential]+[CO
2005-11-30]![Acres-Original Commercial]+[CO 2005-11-30]![Acres-Original Multi
Family]

(I checked the field types; they are numeric.)

Reply to this Message

tina - 17 Jan 2006 17:31 GMT

this formula is in the ControlSource of a textbox control in the report? and
the fields from table [CO 2005-11-30] are part of the report's RecordSource?
if yes to both, then you shouldn't need the table name in the expression at
all, as

=[Acres-Original Residential]+[Acres-Original Commercial]+[Acres-Original
Multi
Family]

if there is any possibility that one of the fields has a null value at any
time, suggest you use

=Nz([Acres-Original Residential], 0)+Nz([Acres-Original Commercial],
0)+Nz([Acres-Original Multi Family], 0)

hth

> I have an expression to sum three values from a linked (to Excel) table. The
> expression was built with expression builder but the reports prompts for
[quoted text clipped - 6 lines]
>
> (I checked the field types; they are numeric.)

Reply to this Message

Steve-in-austin - 17 Jan 2006 19:16 GMT

This worked great! The expression builder inserted the table name so I
thought it was necessary, obviously it's not. Thanks for the null tip; there
are a lot of null values until the DB is populated.

> this formula is in the ControlSource of a textbox control in the report? and
> the fields from table [CO 2005-11-30] are part of the report's RecordSource?
[quoted text clipped - 26 lines]
> >
> > (I checked the field types; they are numeric.)

Reply to this Message

tina - 18 Jan 2006 02:08 GMT

you're welcome :)

> This worked great! The expression builder inserted the table name so I
> thought it was necessary, obviously it's not. Thanks for the null tip; there
[quoted text clipped - 30 lines]
> > >
> > > (I checked the field types; they are numeric.)

Reply to this Message