Hello again
I have a crosstab query which reports on timecodes staff have used.
The format of the codes we use is normally R.Jxxxxxx (where X are numbers)
The format of this field in the table is text.
When the query is run the '.' between the R and J is showing as an underscore.
Any idea what is causing this and how I can fix it?
Thanks!