Hi
Thank you for posting in the community.
From your description, I understand that you would like to know use the table filter-by-form
feature to limit the rows. To do this, you can try use sharp marks (#) to wrap the date, instead
of using the single quotation marks .
You can use the following code to filter the data that have a date greater than a fiven date:
Where date >= #25/12/2000#
I also tested with the sample database Northwind, the following query worked fine:
select * from Employees where birthdate >= #02-06-1963#
and returned the expected results: The detailed informatin of Employees 1 3 6 9.
Please apply my suggestions above and let me know if this helps resolve your problem. If
there is anything more I can do to assist you, please feel free to post it in the group
Best regards,
Billy Yao
Microsoft Online Support
