I merged two different tables into one and made a new table of those two, and no field types have changed. One of my fields (text) stopped returning results, and now is returning this: 쬃C
What in the world did I do???
I merged two different tables into one and made a new table of those two, and no field types have changed. One of my fields (text) stopped returning results, and now is returning this: 쬃C
What in the world did I do???
This usually happens to memo fields, but you say it is a text? The field becomes corrupted, nothing you can do except replace the data.
Unfortunately, aytee111 is right. I would have a go at replacing the data. If you still have the original tables, try exporting them, then import them both to one. Usually this solves the issue.
You say One of my fields (text) stopped returning results, so there is a query involved? If so, you don't have a Group By setting or aggregate function on a memo field by any chance? That would do it. Other than that, I agree. Corruption is often the culprit, and can't be fixed with a compact/repair.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thank you all for your responses. I retraced my steps and it was when I linked two of my queries on the same field was where the corruption happened. So I then made my original queries into tables, then linked again using a different field in both tables that were the same field type. It worked and I got my data back. Still don't know if my result is correct, though.
My question going forward is: what can I do to prevent this from happening again? Do I have to make every query into tables?
I can't thank you all enough for your help on this and my other questions, especially where my understanding of this stuff is barely basic. It's getting better though thanks to all of you
Happy holidays!