Tax ID Madness

[goatley1]

I have some tax id's, in the data view they look as they should 9 digits, but when I get to the table in my report I get either a 1, 2, or 3??  I've ensured the field is read in as text.  Never encountered this problem before.  

[jdbuchanan71 · Accepted solution]

Is it giving you the COUNT of the Tax ID column?  Check the aggregation setting on the field.