I am trying to write a report that includes information from the vendor certificate database. The report must also include the YTD vendor activity. The database that includes the YTD vendor activity isn't part of the primary database for the vendors.
So I created a calculated field that is supposed to go to the vendor activity database and pull that field. The calculated field is named vndact^ytdact
However, when I print the report, instead of printing the value of this field, the report prints "vndact.ytdact"
Can anyone provide a suggestion about what I'm doing wrong? Tech support can't/won't help me ... they referred me to the report writing class. I paid $75 and took that course - and still can't get the field to work. Now what?