John Jnr
Registered User.
- Local time
- Today, 11:59
- Joined
- May 2, 2002
- Messages
- 36
I have a report generated from a form.
In the report I have grouped Expense Type generating a Expense Type Header.
I put this calculated field in the header:
=Sum([ExpenseYear])
And everything works perfectly.
However . . . . . If I put this in:
=Sum("[" & [Forms]![Form6]![Combo0] & "]")
I get that pesky #error
Is it my syntax?
Help much apppreciated.
Cheers
J

In the report I have grouped Expense Type generating a Expense Type Header.
I put this calculated field in the header:
=Sum([ExpenseYear])
And everything works perfectly.
However . . . . . If I put this in:
=Sum("[" & [Forms]![Form6]![Combo0] & "]")
I get that pesky #error
Is it my syntax?
Help much apppreciated.
Cheers
J
