I have the following function: Function Age(DOB, Optional vDate). I want to know if it's possible to call this function in a recordset? For example: DB.OpenRecordset("SELECT Player_No, Player_Name, age(Player_DOB) as PlayerAge FROM Player").

Of course this won't work. Is there any way of doing this? I only want the player's age calculated from his DOB.