Hey! There's more than 2 digits...

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hello all! Using A02 on XP. Have a contributions report
that shows various totals before exporting 18 files so I
can verify each column sub and total will be accurate for
those files. (Columns were formatted 'Number, General'
when imported. Data was imported from a .txt file.)
Sometimes, a number has extra digits like 92.9999, or
54.0556. Because these are pension plan contributions, we
have to contact the client for ALL discrepancies to verify
rounding up or down. I've tracked the data and it carries
the 4 digits all the way in to the report and there they
all of a sudden show as 93.00 and 54.06. Even looking at
the table or query, you have to double-click the expand
bar on the column and then it changes from 93 to 92.9999,
etc. If I could just have a notation (an asterisk) show on
the report on that detail item, we would know to contact
the client. Not sure where and how best to accomplish
this. How can I check for extra digits? Thanks in advance
for any help or advice! You guys have taught me alot since
I discovered you!!! Thanks for being here and taking your
time to help others.
 
Have you tried changing the numeric format on the appropriate report
controls to show the full precision of the numbers that you have? If
you don't want to do that, you can put code in the Detail OnFormat and
OnPrint Events to hide or show an asterisk label based on whether the
full precision value of the datum is equal to itself, rounded to the
number of digits you are displaying. e.g.:

lblAsterisk.Visible = (TheNumber <> Round(TheNumber, intPrecision))

Hello all! Using A02 on XP. Have a contributions report
that shows various totals before exporting 18 files so I
can verify each column sub and total will be accurate for
those files. (Columns were formatted 'Number, General'
when imported. Data was imported from a .txt file.)
Sometimes, a number has extra digits like 92.9999, or
54.0556. Because these are pension plan contributions, we
have to contact the client for ALL discrepancies to verify
rounding up or down. I've tracked the data and it carries
the 4 digits all the way in to the report and there they
all of a sudden show as 93.00 and 54.06. Even looking at
the table or query, you have to double-click the expand
bar on the column and then it changes from 93 to 92.9999,
etc. If I could just have a notation (an asterisk) show on
the report on that detail item, we would know to contact
the client. Not sure where and how best to accomplish
this. How can I check for extra digits? Thanks in advance
for any help or advice! You guys have taught me alot since
I discovered you!!! Thanks for being here and taking your
time to help others.
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Thanks bunches!!! It is something new for me but it made
sense. I'll give it a go as soon as I can. Looks to be
much cleaner and quicker than what I jimmy-rigged. On my
rpt, I had Detail.Visible=No so I set the decimals to 4,
put an unbound field there to parse out the far right
number in the field and if it is greater than zero, place
a note on the header of the report to check data in that
column before finalizing. If the number is good, it will
only have 2 'real' digits and 2 zeros. Only the rounded
number will have the fourth digit.

I really appreciate your advice and the time you take to
give it.
 
Back
Top