You don't provide field types, but if tblSec.SecBloomID field type is the same type as table2.SecBloomID you can link on those fields.
For table names, I used "tblSec" and "tblBloomPrice". Change "tblBloomPrice" to your table name.
Maybe try:
Code:
SELECT tblSec.SecBloomID, tblSec.SecName, tblBloomPrice.BloomSecPrice
FROM tblSec LEFT JOIN tblBloomPrice ON tblSec.SecBloomID = tblBloomPrice.BloomSecID
ORDER BY tblSec.SecName;
"tblSec.SecBloomID" should be unique.
"tblBloomPrice.BloomSecID" would NOT be unique.
As I said before, just curious. If you can link to Excel, you should be able to link to Access and cut out the middle man.
Good luck on your project.....