It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Help in MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Help in MS Access" Watch "Help in MS Access" New topic

Help in MS Access

Kameswari Charan

Joined: Jul 22, 2003
Posts: 1
I want to select the birtdays of all employees in my office which falls on the current date in MSAccess.I have used the following code but it doesnot work..
SELECT BD_Details.CPFNo, BD_Details.[First Name], BD_Details.[Last Name], BD_Details.Birthday
FROM BD_Details
WHERE format(BD_Deatils.[Birthday],'mm/dd')=format(now(),'mm/dd');
Can anyone please help me.
I agree. Here's the link:
subject: Help in MS Access
It's not a secret anymore!