Hi,
I have a table that has a lookup field (Job title) linked to Jobs table. The data type appeared as "Number". However, in the table the text value appeared. I created a query and added the job title field and it also appeared as a text, however, when I created a report and added a chart displaying job title data, the data appeared as numbers instead of text.
I've been struggling with this for days now, how should I fix it?