General information
Title:
Calculated Fields in Reports
I'm coming from a dBase and Visual FoxPro background and trying to figure out how to work in a world without command lines in Access97. I want a field/control in my report to combine two trimmed fields as one. Real straightforward, I've got Last (name) field, First (name) field and I want my report to list:
Doe, John
Smith, Mary
Tried using expression like "Trim(Last) + ", " + Trim(First)" as an expression in a control, but it's acting like a parameter
and asking me what contact I want and entering 'Error' in the report.
ideas?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only