Aug 17 2006, 03:58 AM
I've never seen this effect before. I have created a report from a query that contains a mixture of text and number fields. One of the fields is date, another is postcode (UK). The postcode is a text field. When I run the query the data shows correctly, but when I add them to the report the numbers are missing. For example 17/08/2006 appears as
and a postcode of AB12 3CD appears as
The report prints out like that too. Thanks in anticipation.
Aug 17 2006, 05:22 AM
Post a copy of your database, sounds very strange.
Aug 17 2006, 09:28 AM
Thanks for your reply John.
The same thing happens with another database that was previously fine. However, opening the same databases on different machines doesn't show the problem. I'm thinking it's a corrupt installation. Detect and repair hasn't solved the problem, so I'll get IT to reinstall.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here