I mistakenly (now I find out) created a lookup field (Name of Event) that looks up Event Names in the Event Table.
I now know that it saves the Event Name as a numeric value. Can I go back and change this to save the data as the Event Name text, instead of the numeric value, without losing the data I have.
The select queries work fine, displaying the actual text Event Name.
However, I have a need for a Union query and that union query is displaying the numeric value instead of the text value Event name.
Or, is there a way to write something into the SQL in the union query to display Event Name as text?
Thanks in advance.