hi, i am new at access 2007 and my problem is that i want to make a button in a form to filter the data to the current date or today’s date.
this is what i have:
Action: Applyfilter
Filter name: (blank)
Where condition: [Date] like “=date()”
control name: (blank)
i guess it doesn’t work
can any one help me with this.
one more thing if i use something else in where condition like:
[name] like “George” it does work but if i put
[date] like “12/5/2011” it doesn’t work i wonder why?