concatenation field behaving strangely
I am displaying a field from a related table on the layout of a report. The field is defined to display a concatenation of several ingredients followed by the percent of those ingredients. When I view the field in the report though, it displays a seemingly unrelated number. If I select the field, then it instantly displays the concatenation correctly. I'm thinking it must have to do with the way the field is specified in this specific layout?
I apologize if this has been answered before, I couldn't find it in the forums. I'm sure it is a simple problem to fix, right?