Wierd characters in union query results (2000)

I am getting two little squares returned in the cells of a union query where I would expect to see currency amounts. The two little squares look like the characters that are sometimes displayed when Access comes accross ASCII codes that it doesn't know how to print.

The union query combines two queries, one showing invoice details and one showing payment allocation details, and each works perfectly when run on its own. The idea is to create something like a bank statement, showing money in and money out on the same report.

The currency amounts that are showing as little squares come from the payment allocations query and are displayed correctly in that query. The invoice query also populates currency cells and these display as expected in both the original query and in the union query. All the other fields from both queries are also output as expected in the union query. I am mystified.

Re: Wierd characters in union query results (2000)

Yes, that's where I've seen these characters before. But the columns in question are of type currency (which I assume means that they cannot contain CRs) and the data in them is displaying correctly in the query that forms one half of the union query. It's only in the union query that I get the problem.