How do I build an expression that calculates the results of mathematical functions in other controls? Every time I think I have it right, it returns a "Name?" or "Error" in the report.
How do I build an expression that calculates the results of mathematical functions in other controls? Every time I think I have it right, it returns a "Name?" or "Error" in the report.
or whatever the expression might be in a vacant Field cell in a Query.
The key points - use an alias name for the expression followed by a
colon; this name must be different than any field in the table. Access
will supply Expr1 (Expr2, etc.) if you don't give your own. Also, use
fieldnames enclosed in brackets; if there is any ambiguity about which
table the field is from, use the table name as above (otherwise it is
optional).
It's more than a bit difficult to tell what you might be doing wrong
since you don't tell us what you're doing... but give the above a try,
or post back with more details.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
