Here is how I would do this assuming this is the proper table structure:
notes.ID - PK (bad name since PK should be table name + ID, Pascal cased, no periods.
DonationsID - PK
Date - (bad name for this field as its a reserved name)
notes.ID - FK tblMain
Open the query builder in design view.
Add tblMain and tblDonation to the design window.
Select the requisite fields from each table that you want.
Sort the Date Ascending
If you want to get some criteria from the user during the query runtime, then enter this on the criteria line:
Like "*" & [Enter Desired Match data:] & "*"
This will allow you to look for a match in the middle of the string. If it will always be at the beginning or end, then remove the other asterisk accordingly.
If you want to pass the Desired Match data from a combo box on a form, then I can show you how to do that.