E eran185 Registered User. Local time Today, 05:25 Joined May 11, 2007 Messages 55 Jun 10, 2007 #1 hey i have a simple form , based on a simple table. i build a imple query that take the date between today and the date the user want. but the query doesn't work Attachments test1.zip test1.zip 35.9 KB · Views: 121
hey i have a simple form , based on a simple table. i build a imple query that take the date between today and the date the user want. but the query doesn't work
A AlanJ10 Registered User. Local time Today, 13:25 Joined Feb 20, 2007 Messages 38 Jun 10, 2007 #2 In your WHERE clause "today" just means the string "today", not today's date. Replace it with date() (no quotes) and that will return today's date.
In your WHERE clause "today" just means the string "today", not today's date. Replace it with date() (no quotes) and that will return today's date.
