F fckPolice Registered User. Local time Today, 07:25 Joined Nov 12, 2004 Messages 11 Nov 12, 2004 #1 kids. i am creating both an append and delete query and would like to have it query by the day's date without having to enter it everyday...is there a bit of code to do so? thanks.
kids. i am creating both an append and delete query and would like to have it query by the day's date without having to enter it everyday...is there a bit of code to do so? thanks.
Newman Québécois Local time Today, 10:25 Joined Aug 26, 2002 Messages 766 Nov 12, 2004 #2 In Access queries use: =Date() In SQL queries use: =Sysdate()
F fckPolice Registered User. Local time Today, 07:25 Joined Nov 12, 2004 Messages 11 Nov 12, 2004 #3 thanks a ton...that makes things sooooo much easier