I am trying to use the DSum function on a form, however if I try to use it with a fieldname that begins with a numeric character (eg; “2013Sales” ) it throws an error.
If I change the fieldname (eg “Sales”) the error doesn’t occur, however the original field name works fine in other queries/expressions etc;
Does the syntax of the DSum expression need to change because of the character types in the fieldname or is using numeric characters in a field name always going to cause problems???
If I change the fieldname (eg “Sales”) the error doesn’t occur, however the original field name works fine in other queries/expressions etc;
Does the syntax of the DSum expression need to change because of the character types in the fieldname or is using numeric characters in a field name always going to cause problems???