I'm trying to run a script which will find records which have 10 as the month using wildcards.
Contrived I know, but its for a solution to an exercise written for Access, I'm adapting the questions/answer for my pupils.
Script I have written is as follows:-
ExecuteSQL ( "
SELECT MembershipNumber, DateOfBirth, TypeOfMember FROM Member
WHERE TypeOfMember = 'Adult' AND DateOfBirth LIKE %10%
Any ideas how to get this working?
What is the correct syntax for the use of dates in ExecuteSQL?