#Type Error

[tomnsd]

I am trying to use a formula in a report control

[Weight]/[Table]

. Both the fields are from a table called PL_Summary_2 and both fields are numeric in the table. When I run the report I get a #Type! error returned. I imagine the table needs to be referenced in the formula, but I am not sure of the Syntax.

[June7]

The expression is in textbox ControlSource? Did you precede the expression with an = sign?

It is not required to prefix with table name unless the datasource is a query joining tables that provide fields with the same name.

[tomnsd]

Yes, it is a text box and it is proceeded by "="

[June7]

Then I have no idea why this errors. If you want to provide db for analysis, follow instructions at bottom of my post.

[ssanfu]

I'm not saying that this is the problem, but you have

[Weight]/[Table]

"Table" is a reserved word in Access. Reserved words should not be used as object names.

A list of reserved words is at
http://allenbrowne.com/AppIssueBadWord.html

Using a naming convention tends to avoid this reserved word problem.


Another thought..
In form design view, check to see if the field names you typed in the control are in the Field list available to the form.
I use A2000, so I don't know where the field list button is located in the ribbon.

[June7]

Yes, good to avoid reserved words (as well as spaces and special characters/punctuation - underscore is exception), however, the [] should force acceptance of the field name.

The field list can be activated on the Design tab > Tools section > Add Existing Fields.

[tomnsd]

I've attached the Access Database with the problem. Please look at the report.

Thanks.

[June7]

With the report in design view you will see a little green triangle in the upper left of the textbox. Click it and you will see explanation of the error. All of these textbox errors are due to circular reference. Give the textbox a name different from field referenced in the expression, like tbxWeight.

[ssanfu]

I would do all of the calculation in a query instead of in the report controls.
Much easier, IMO...