Baffled by access report anomaly displaying data

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,

We're experiencing very strange behavior with an Access 2000 report. We use
a query as the recordsource for the report. The query is based on several
underlying queries and has numerous fields which are dollar amounts. When
the query is run by itself all the values look fine and show the correct
dollars and cents. But the report does not seem to recognize the fractional
part for one particular field (i.e. the query shows 326.75 but the report
shows 326.00). Meanwhile all the other fields appear fine in both the query
and the report and all the fields are defined the same way on the report.
Yet only this one field loses the fractional part. At first, we did play
around with the textbox properties on the report (Format, Decimal Places,
etc) but it didn't solve the problem. The only thing that changed was
whether the value displayed as 326.00 vs. 326 -- but the .75 never appeared.

To try to isolate the problem we created a new report. At first we added
just the field in question to the Detail section and the value appeared
correctly as 326.75. But as we rebuilt the report adding other fields,
groupings, totals, etc., somewhere along the line the same problem was
reintroduced. After much experimenting we discovered the cause but
unfortunately have no idea how to get around it. For some inexplicable
reason the problem occurs as soon as EITHER of the following happen:

1. Any "Sorting and Grouping" fields are specified for the report
2. Any data fields (from the query) are added to the Report Header/Footer
sections. Literals, labels, and functions (Now(), page numbers, etc) in
these sections do not cause the problem.

So when both of the above situations are eliminated the field properly
displays as 326.75. Needless to say we are baffled by this.

Teri


.

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)