When I run my query access crashes. If I remove the SuperPrice select statement it works fine. I'm using Windows7 Ultimate 64, Access 2007 SP2. Any help would be appreciated.
SELECT Parts.*, DealerParts.Bin, DealerParts.Note, (SELECT RetailPrice FROM Parts P WHERE...