I am relatively new to Access, but have a firm grasp of report formatting and expected results. Here is my issue:
I have a user whose front end is generating reports where the queried numbers are not formatting. Instead of printing 2501, it is attempting to print 2500.95969948484, which is printing on the report as ##############. This makes sense on quite a few levels, until further investigation is done. I have another front end which was designed slightly different for a different user. However, the report is identical. When I run both front ends on the same computer, one of them works with auto-formatting (resulting in "2501"), while the other continues to print #########. This issue just started about a week ago, but I do not know what might have changed to cause the report to change. The report in question has been used effectively by multiple users for at least 2 years.
I have tried the following:
1) I have forced the report fields to 2 decimals and to 0 decimals. I still get hashes. Forced output of integer does not change this either.
2) I have tried resizing the fields, but end up making them 4x larger before I get any results -- even when I change the decimal.
3) I have renamed this report and copied the working version from front end #2. Results are the same. The "new" report malfunctions the same way.
4) I have looked at the query generating the report and both front ends use identical queries. Both front ends are linked to the same back end tables.
Any suggestions or comments? It cannot be the version of Access, since both FE1 and FE2 were run on the same computer at the same time, with different results. (If it does matter, most of the programming was done in Access 2003, this user has Access 2007. In a copy of the front end to my machine, running Access 2003, the report runs as intended.)
Any help would be nice.
Yours confusedly,
Danielle