I think the answer to my question may be yes, but maybe not. At least at present I've been unsuccessful in constructing one.
Throws an error.
Here's what I want the default value of the field ItemValue (currency) to be:
Divide the field FullUnitCost (currency) by the field NoInFull (numeric), then multiply the result by the field CumTally (numeric)
and round the result to 3 decimal places.
So the expression would be--
=Round([FullUnitCost]/[NoInFull]*[CumTally],3)
Now if I put this expression into an unbound field on a report form based on the table in question, it works.
But I was thinking it might be smoother if this calculation could just be built into the table design itself.
If this isn't possible, I'm fine with doing the calcs in the report, but I just wondered if this could be done
in the table design. No problem, of course, if one is going to use something like "United States" or "John".
But Access doesn't seem to like an expression like the above in the Default Value field of a table design.