Wow! Finally I found the solution to this error. As it turns out it was a combination of the query statements from 'Mike Meinz' and 'karthikeyan_kk 730'.
Code:
SELECT CPR, FName, LName, CPRIdt, CPREdt, nation, Gender
FROM Emp_master
WHERE (CPREdt >= now) AND (CPREdt <= now + 15)
As it turns out, the 'now' function is what Access takes as the current DateTime. Adding additional days would be simply like 'now+15'. I implemented Mike's idea of the now function into karthikeyan's code and voila, it works like a charm.
Thank you very much to 'Mike Meinz' and 'karthikeyan_kk 730' for your guidance.
Regards.