Report Control Error

[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.

 

[Marshall Barton]

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.

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.

 

[Kevin Sprinkel]

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.