I try to making Birth Day reminder project, from VB.Net and MS-Access
There are Two tables, "Visitors" and "Employees"

"DateofBirthDB" field in Two tables with same format. (some few different fields also in Two tables)
I want to select all upcoming birth days from today onwards upto Yesterday,

Please expalin me to use "Select" query to get From Today to Yesterday.
(Only Month and Day)

Today is 07-12-2013 then I want to select
07-Dec --- to ---> 06-Dec (that mean Jan,Feb.... then Yesterday) - in Order

try this

select * from tbl
where DateOfBirth >= addDate(day,-1,getdate()) and DateOfBirth <= getdate() 

you can also use between clause in where condition.

Hope this will give you any idea.