I've got two tables of various information about members of a club I'm helping run and I'm now trying to create queries I can use so I won't have to redo filters constantly to extract various information I need.
Where I have issue is that I create a query that pulls table fields from the two tables (linked via one-to-one relationship), and I need to only see members that are under 18 years old on the date I run the query (due to rules about Minors I need to keep regular updated lists on who they are)
In the field properties for the BirthDate column in the query I created I go to the Criteria field and enter the following, that I've found listed as example on various online guides:
It gives me syntax error on the first comma as soon as I hit enter or try to leave the field. As far as I can see the formatting is right but I'm quite certain I'm missing something basic that I've completely overlooked here.
Using Access 2007.
And am sort of around novice level.
Where I have issue is that I create a query that pulls table fields from the two tables (linked via one-to-one relationship), and I need to only see members that are under 18 years old on the date I run the query (due to rules about Minors I need to keep regular updated lists on who they are)
In the field properties for the BirthDate column in the query I created I go to the Criteria field and enter the following, that I've found listed as example on various online guides:
Code:
DateDiff ("yyyy", [BirthDate], Date()) -18
Using Access 2007.
And am sort of around novice level.
Comment