Query Access Question With one table tblBids containing BidId field with the relationship bidID has multiple contractors from tblContractors, I am trying to create a query which will list each contractor and email address related to their BidID.

BidID      Contractor Name     Contractor Email
1          Contractor A        Contractor A Email
1          Contractor B        Contractor B Email
2          Contractor A        Contractor A Email
2          Contractor C        Contractor C Email


My goal is to create a Send Object Command to send a PDF Report out for say BidID 1 to all contractors selected to that Bid ID.

Any ideas?
This answer presumes there is no many to many table with BidId related to ContractorId which should probably exist.  Examples of the tables from which you are querying are as helpful as seeing the example of expected result.

DECLARE @BidId int = 1

    SELECT BidID, ContractorName, ContractorEmail 
    FROM tblBids B
    JOIN tblContractors C
    ON B.ContractorId = C.ContractorId 
    WHERE B.BidId = @BidId