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))
Leave a comment
*high five*
Reply
Reply
Reply
Public Function Apology() As Object
Dim strSQL As String, Accepted As Boolean
strSQL = "UPDATE Public_Record.Statements SET Apology = True WHERE ((Conversations.PersonID = " & DLookup("[Person_ID]", "[Friends]", "[Name] = 'Dan'") & ") AND (Conversations.Inspiration <> 'Me') AND (Conversations.Date = #02/23/2007#) AND (Conversations.Topic = 'SQL'))"
Do Until Accepted = True
DoCmd.RunSQL strSQL
Loop
Resume Friendship
End Function
Reply
run
Reply
Leave a comment