Data Changing on Report

  • Thread starter Thread starter aMack
  • Start date Start date
A

aMack

I am pulling my hair out:

2 fields:

[OM 2 Rate] is Numeric, Long, Standard and 2
[OM 2 FSC] is Numeric, Double, Percent and 2

In a query the result for record# 32159 is 0.00 and 0.00 for each field.

In a report I have the two combining as:[OM 2 Rate]*(1+[OM 2 FSC]

The result is the dollar amount from another field - [OM 1 Rate] ($175.00)

If I modify the report to be just [OM 2 Rate] the result is 0.00

If I modify the report to be just [OM 2 FSC] the result is 0.00

If I modify the report to be =1*[OM 2 Rate] the result changes to $175.00

I tried deleting the report field and adding from scratch - no good.

????????? Please help - any suggestion would be great
 
It sounds like you might have some corruption in the report.
Try rebuilding the report from scratch.



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
The two combined should be [OM 2 Rate]*(1+[OM 2 FSC])

You missed the closing parenthsis on the end.
 
I didn't miss the closing parenthesis in the report just in my discussion
posting.

It turns out that [OM 1 Rate] field in the report showed the control source
as [OM 1 Rate] but the text box was [OM 2 Rate]

Problem resolved.

Thanks all.
--
A MACKENZIE, CMA, MBA


KARL DEWEY said:
The two combined should be [OM 2 Rate]*(1+[OM 2 FSC])

You missed the closing parenthsis on the end.

aMack said:
I am pulling my hair out:

2 fields:

[OM 2 Rate] is Numeric, Long, Standard and 2
[OM 2 FSC] is Numeric, Double, Percent and 2

In a query the result for record# 32159 is 0.00 and 0.00 for each field.

In a report I have the two combining as:[OM 2 Rate]*(1+[OM 2 FSC]

The result is the dollar amount from another field - [OM 1 Rate] ($175.00)

If I modify the report to be just [OM 2 Rate] the result is 0.00

If I modify the report to be just [OM 2 FSC] the result is 0.00

If I modify the report to be =1*[OM 2 Rate] the result changes to $175.00

I tried deleting the report field and adding from scratch - no good.

????????? Please help - any suggestion would be great
Click to expand...
Click to expand...
 
Back
Top