seekinganswers
Technical User
I need to find the lowest bid of a line item. Then I need to sum each vendors lowest bid for a report.
My Tables:
TblBid TblLineItems TblVendor TblBidTrack
BidID LineItemID VendorID VendorID
BidNo BidID VendName BidID
BidDate Desc LineItemID
TypeMaterial Quantity AmtBid
Requestor
Dept
I need to sum all of a vendors bid per bidno, then I need to sum all of a vendors LOWEST bids per bidno (that's the amount awarded). Example report follows:
BidDate
BidNo TypeMaterial/Requestor/Dept.
Amt. Bid Amt. Awarded
ABC Vending $1,096.00 $1.000
It's even more complicated then this though. If a Vendor doesn't bid, I need the text "No Bid" to appear. And, if a vendor doesn't bid on every line item, I need to show a 'P' next to their summed amount bid. I think I worked out the if statements for those if someone can help me figure out how to calculate Amt. Awarded.
Can anyone point me in the right direction?
My Tables:
TblBid TblLineItems TblVendor TblBidTrack
BidID LineItemID VendorID VendorID
BidNo BidID VendName BidID
BidDate Desc LineItemID
TypeMaterial Quantity AmtBid
Requestor
Dept
I need to sum all of a vendors bid per bidno, then I need to sum all of a vendors LOWEST bids per bidno (that's the amount awarded). Example report follows:
BidDate
BidNo TypeMaterial/Requestor/Dept.
Amt. Bid Amt. Awarded
ABC Vending $1,096.00 $1.000
It's even more complicated then this though. If a Vendor doesn't bid, I need the text "No Bid" to appear. And, if a vendor doesn't bid on every line item, I need to show a 'P' next to their summed amount bid. I think I worked out the if statements for those if someone can help me figure out how to calculate Amt. Awarded.
Can anyone point me in the right direction?