seekinganswers
Technical User
I can't seem to get my head around this one. A public school sends out requests for bids. The vendors fill them in and return them. Upon return from the various vendors each bid is compared line item by line item. If a vendor bids low on line items 1 and 6 that's all the vendor is awarded. My problem is the report that must be generated for the Board. Following is an example.
BidNo Vendor AmtBid AmtAwarded
AmtBid must the total that the vendor bid for that particular BidNo. However, the AmtAwarded must be the total of those line items awarded to the vendor. I can view the results I want in a pivot table using MIN, but I can't seem to figure out how to put this in a report. I've manipulated the data with crosstab after crosstab never achieving the desired result.
Can anyone help?
BidNo Vendor AmtBid AmtAwarded
AmtBid must the total that the vendor bid for that particular BidNo. However, the AmtAwarded must be the total of those line items awarded to the vendor. I can view the results I want in a pivot table using MIN, but I can't seem to figure out how to put this in a report. I've manipulated the data with crosstab after crosstab never achieving the desired result.
Can anyone help?