Report expression builder parameter value

[Steve-in-austin]

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.)

 

[tina]

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

 

[Steve-in-austin]

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?
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
"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.)

 

[tina]

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
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?
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
"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.)