expression builder problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have a calculated field. If I type [expenses]*.15 in controlsource,
it works. However if clicked on the ellipsis to go into expression builder, i
need to click on tables, then double-click on Expenses then I complete the
formula. But there I see [Table1]![expenses]*.15, which does not work and I
get #name? What is going on? What wrong was I trying? Thanks
 
Hi

The expression builder is useful in that it can help with syntax but it
won't prevent you from creating an expression that isn't valid where you are
trying to use it.

In your case I presume you are putting a calculated field on a form.

And, your calculation involves multiplying another item (expenses) that is
on the form.

So, in the expression builder, you should choose forms (not tables) and then
loaded forms and then the form these items are on.

Then you can pick expenses and enter the rest of your expression.

hth

Andy Hull
 
Back
Top