It sounds as though you are new to Access and have imported an Excel
spreadsheet into an Access table perhaps.
There may be a way to do what you are asking, but I think most folks here
would recommend that you use Access as what it is, a relational database.
This would involve having a table for vendors and a table for products and a
table for Product XRefs. Done this way, the query you are interested in
would be a simple totals query grouping by item number and VendorName and
pulling Min price/bid.
A typical Products table:
ProductId- Autonumber
ProductName
ProductDesc
OrderMethodCode
CommodityCode
Etc
A typical Vendor table:
VendorId- Autonumber
VendorName
VendorAddress
VendorCity
VendorState
VendorZip
VendorPhone
Blah, blah, blah
A typical VendorXRef table
XRefId- Autonumber
ProductId
VendorId
VendorXRef
Bid
BidDate
Your query would consist of the ProductName field from Products, Bid from
the VendorXRef table, and VendorName from the Vendor table. After adding
these fields to the QBE grid you would click View>Totals and
in the Totals Row of the QBE grid under Bid instead of the default "Group
By" you would select "Min".
Hope that helps.
