In this Microsoft Access video tutorial, you will learn how to create a query showing today's birthdays using the MONTH, DAY, and DATE functions. This is handy to generate a list of birthdays anniversaries, employee evaluation dates, and much more. Click here for the video.

Upload Images   Link  Sim Kosal  6 years ago I like this web Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

New Access Tip List of Birthdays Upload Images   Link  John Davy  7 years ago Great job! I am impressed with your teaching. Thanks John Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

New Access Tip List of Birthdays Upload Images   Link  pretty nicole  9 years ago Hello! I'm just a newbie in access 2007. Hopefully you can help me about this matter. This is a great tutorial but I want to generate the query to the Report Design. May I know, on how to do that? Thanks! Read More... Reply from Richard Rost: Nicole, you just create a new report and base that report on the query you just created. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Waiting list Upload Images   Link  James F  9 years ago Hi Richard Do yo know when the waiting list page will be fixed, as I'm wanting to cast my vote for the ASP/Access seminar. Also, how's the Search seminar coming along Reply from Richard Rost: Read More... It's only my list of items that still need fixing. I hope to get to it today. The seminar has been pushed back a bit until I get the whole web site up and running at 100%. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

SL No in forms Upload Images   Link  amutha  9 years ago pl. help Reply from Richard Rost: I'm sorry, but you'll have to be a little more descriptive than that. :)  What is an SL No? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

New Access Tip List of Birthdays Upload Images   Link  Jeannine Ryan  9 years ago I think so, I'll have to check tomorrow because I have to leave work now. I am very grateful for your help. I will contact you again if I can't figure it out. Have a wonderful evening. :-) Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

New Access Tip List of Birthdays Upload Images   Link  Jeannine Ryan  9 years ago Hello & thanks for the speedy reply! I watched a tutorial on how to have Access calculate an accurate age for my clients. I double-checked my spelling and spacing and tried again. It still did not work. I used the following: Read More... Age: DateDiff("yyyy",[DateOfBirth],Now()) Reply from Richard Rost: And do you have a field named EXACTLY "DateOfBirth" in the underlying table? It can't have any spaces in it. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

New Access Tip List of Birthdays Upload Images   Link  Jeannine Ryan  9 years ago Hello there and thanks for your helpful site. I have a quick question. When I try to complete a query to calculate the age of my clients based upon their Date of Birth, it asks me to "Enter Parameter Value" for DateOfBirth. I'm not exactly sure what to put here. Can you please help me or guide me to a tutorial that will explain this to me? Read More... Thank you very much!  :-) Reply from Richard Rost: That just means that you have something misspelled. Access is looking for a field called "DateOfBirth". What do you currently have it set to? I'm assuming you're using a calculated query field. Are you using the DateDiff function to figure the age? Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

New Access Tip List of Birthdays Upload Images   Link  najeebkhan  9 years ago this is so important for me Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

New Access Tip List of Birthdays Upload Images   Link  Mubeezi Micah  9 years ago wow! another great tip. i liked how u added the criteria in the query. MICAH Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Show Older Comments...
View in Table Format