I have a table containing a field in a formate of a date, and I want to create a query returns all records of a spesific month in any year, I have found exactly what I need in the access help, but it does not work!!!!
The code to be written in the criteria cell is- as mentioned in the HELP- is:
DatePart("m", [SalesDate]) = 12
It means to return all values took place in December of any year.
For now it is good, but the problem is that there is an error which I wounder about, the error says: "THE EXPRESSION YOU ENTERED CONTAINS INVALID SYNTAX
......., you entered an invalid characters or commas"
This is the error message, and when I press Esc I find the comma selected (flasher selection), as if it wants to say that it is wrong to write this comma.
NOTE:- The above-mentioend code is copy and past from the help!!!!!!!!
What is the reason of that, and however, what is the way for doing so?????
Thanks a lot
