AnsweredAssumed Answered

Help with value list in reports

Question asked by kjw282 on Feb 26, 2018
Latest reply on Feb 26, 2018 by beverly

I have a value list of applicable grade numbers for schools (IE:  K, 1, 2, 3)  which represent what grades a particular school covers.  Previously, I had the grades without the comma separating them but since I have to use this information in a report to an outside agency, I decided to include a comma after each grade number so when it prints in the report, it is clearly distinguishable.  Problem is:  When I changed the value list to numbers with commas, for some reason the schools appear with both the version without commas and the version with commas in a report.  When I look at the record in Browse Mode Form View, the grade levels only appear with the commas but if I look at it in Table view, it shows both versions.  First what caused this and last how to fix quickly?

Outcomes