I stuck with this problem,
Im using ODBC to extract data from MSAccess Tables.
All works fine when querying for all data from the table:
SELECT * FROM Person
But I want to be able to extract only the records with its DOB field within the current month.
Ive used the "SELECT * FROM PERSON WHERE EXTRACT(MONTH FROM DOB) = variable month" statement on Paradox tables and it works fine
Is there an equivelent statement to use in querying MSAccess Tables to only retreive record that are relevant to the current or selected month.