That would be my first guess... just seems odd that a chunk of consecutive rows for over a year show that and in that time period there's no "real" data. The afore mentioned 3 character column is only used for numbers, and the ASP form taking input has an integer-only check before submitting the form, so seeing "(de" in that column doesn't fly with the "test" scenario. I know Access likes to show #VALUE for things it can't understand so I was hoping this was a similar side effect. I'm sure something broke along the way, but I just don't know what it would have been. I showed it to the people who use the data and they're just running with it.
|