L
Luis Bernardo
Hi,
When using expressions in aggregate functions within an
Access Project (.adp), it returns #error. For example:
Using the following textbox on form's footer:
name = grandtotal
controlsource= sum([price]*[quantity])
This returns #error in an access project (.adp file), but
it works fine in a normal database (.mdb), giving me the
expected results.
The same happens if I try to use controlsource = AVG
([orderingdays]+[shippingdays])
If i use controlsource = sum([price]) or controlsource=sum
([quantity]) the results show as expected.
Does anyone know why this is happening?
When using expressions in aggregate functions within an
Access Project (.adp), it returns #error. For example:
Using the following textbox on form's footer:
name = grandtotal
controlsource= sum([price]*[quantity])
This returns #error in an access project (.adp file), but
it works fine in a normal database (.mdb), giving me the
expected results.
The same happens if I try to use controlsource = AVG
([orderingdays]+[shippingdays])
If i use controlsource = sum([price]) or controlsource=sum
([quantity]) the results show as expected.
Does anyone know why this is happening?