Feb 23, 2007 21:28
SELECT TOP 3 Food.* INTO Stomach FROM (Refrigerator INNER JOIN Pantry ON Refrigerator.Shelf = Pantry.Shelf) WHERE ((Food.Taste >= " & DLookup("[TasteValue]", "[Tastes]", "[Taste] = 'Good'") & " AND (DateDiff(dd, Food.Date_Purchased, GetDate()) <= 7))