S
Slez via AccessMonster.com
I need a little help with how to structure an expression. I'm trying to
establish some totals on a report with some specific contitions. My fields
are as follows:
[BidType] has 3 possible values - Alternate, Base Bid, Budget
[BidStatus] has 4 possible values - Awarded, Not Awarded, Pending, Void
I need the sum of records of a control called txtBidTotal where [BidType]
equals "Alternate" or "Base Bid" AND [BidStatus] equals "Awarded".
I have created Iif statements with one condition, but would appreciate some
help with how to structure this multi-condition one. Thanks in advance for
any help!
Slez
establish some totals on a report with some specific contitions. My fields
are as follows:
[BidType] has 3 possible values - Alternate, Base Bid, Budget
[BidStatus] has 4 possible values - Awarded, Not Awarded, Pending, Void
I need the sum of records of a control called txtBidTotal where [BidType]
equals "Alternate" or "Base Bid" AND [BidStatus] equals "Awarded".
I have created Iif statements with one condition, but would appreciate some
help with how to structure this multi-condition one. Thanks in advance for
any help!
Slez