I am using the Right function in a text box in a report to return the characters from the right side of a string:
Right(string, length)
This has worked in another exact copy of the report in a different database (all running Access 2003) but I am now getting an error message (still works in the other versions on the same computer):
Thanks.
Right(string, length)
This has worked in another exact copy of the report in a different database (all running Access 2003) but I am now getting an error message (still works in the other versions on the same computer):
The function you entered can't be used in this expression.
* You may have used an aggregate function, such as Count, in a design grid or in a calculated control or field.
I'm pretty sure it's the Right function that is the problem. Any ideas?* You may have used an aggregate function, such as Count, in a design grid or in a calculated control or field.
Thanks.