Chinese Characters in a query that pulls a date from a form

[snipe]

Ok I think I broke everything.



In short, I have a query that pulls a "fromdate" and a "todate" from a form, and runs a series of queries then a report. The first query is an append query. If I choose to just view the data, the two date fields in the query have chinese characters in them. There is no memo field, there is no Totals. I have reduced the query down to 3 fields: from, to, and "ticket number." Both the from and to fields are blank, until I click in one of them and 2 chinese characters appear. I have done a C&R, I have decompiled, I am completely stumped.


To cause this:

I imported two excel spreadsheets that I was going to have to do some quick work on (separately), call them A and B. I used A first, made the queries and the report and it worked great. Instead of redoing all of the code to look for B, I renamed A to Ax and renamed B to A. Everything broke then. I renamed them back to the original, I deleted them, nothing fixed it.

Ideas?

[rpeare]

Where's the spreadsheet coming from? does it even make sense that there would be chinese characters in the body of the spreadsheet?

Can you provide a sample of the spreadsheet?

[snipe]

Turns out my database had some wicked corruption. I had to revert to yesterday's back up. Everything is great now.