Report Control Error

  • Thread starter Thread starter Kevin Sprinkel
  • Start date Start date
K

Kevin Sprinkel

qryrsubBidReturn_Bids is the source query which includes
the following fields:

JobNumber Text
BidType Text
AwardedBid Yes/No
Amount Currency
Delta Calculated numeric field

I'm trying to get the following output:

Bid Amount Delta
=========== ============ ========
LOW 18,456,000 -2.4%
HI 22,000,000

....that is, only printing a Delta for the awarded bid.

Setting the report control to:

= IIf([AwardedBid]=True,[Delta],"")

generates #ERROR as the output for the awarded bid, but
successfully prints a blank for the others.

I can't find my error. Anyone?

Thanks.
 
Kevin said:
qryrsubBidReturn_Bids is the source query which includes
the following fields:

JobNumber Text
BidType Text
AwardedBid Yes/No
Amount Currency
Delta Calculated numeric field

I'm trying to get the following output:

Bid Amount Delta
=========== ============ ========
LOW 18,456,000 -2.4%
HI 22,000,000

...that is, only printing a Delta for the awarded bid.

Setting the report control to:

= IIf([AwardedBid]=True,[Delta],"")

generates #ERROR as the output for the awarded bid, but
successfully prints a blank for the others.
Click to expand...


The textbox mst have a different name than the fields that
are used in its expression. Change the name of the text box
to something like txtDelta.
 
Thanks, Marsh. As a new developer, I've been very careful
about normalization, and consistent and conventionally-
named fields and form controls, but for some reason slip
on the reports. :^)

All is now well; thank you.
 
Back
Top