Assist with MS Access query/VBA to calculate age in years and months.

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I am building a database for a preschool and need to calculate the children’s ages in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes.

Excel Microsoft Access SQL Visual Basic Visual Basic for Apps

Project ID: #17866887

About the project

22 proposals Remote project Active 5 years ago

Awarded to:

sambestsolutions

Hi I am an engineering undergraduate with exceptional skills in mathematics. I am well experienced in using excel vba macro functions for various complex mathematical calculations. I can easily do this. can provide yo More

$35 AUD in 2 days
(7 Reviews)
3.4

22 freelancers are bidding on average $80 for this job

schoudhary1553

Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Assist with MS Access query/VBA to calculate age in years and months. I've delivered more than 400 + projects in the la More

$250 AUD in 4 days
(348 Reviews)
8.0
paris2785

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Access because this is my favorite field and MS Access projects are among the tasks I work wi More

$80 AUD in 0 days
(297 Reviews)
7.7
TonmoyRoy111

Dear Client I can do the job for you. I have strong hold in excel and vba............................... Kindly contact me. Roy

$100 AUD in 1 day
(355 Reviews)
6.9
polarjin2017

VBA is my talent. So I think I can help you if you want. I will never disappoint you. Hope to work with you. Thank you.

$133 AUD in 3 days
(107 Reviews)
6.8
avinav606lx

Hello there, Share your sample file. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Access/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to disc More

$45 AUD in 3 days
(195 Reviews)
6.7
jonathanpradas

Good day. The time frame and the bid amount are final since this requirement is pretty easy. I have been using MS Access for my personal and professional use and I can guarantee you that I can finish the project on as More

$50 AUD in 3 days
(57 Reviews)
5.5
sonarkaushik

I am very able to set up Access querues / vba to calculate age flawlessly as per your requirement. I am ready to start. regards

$99 AUD in 1 day
(48 Reviews)
5.6
dionisiotumbaga

Hi, I am interested. I would be happy to discuss......................................................................................................................................

$40 AUD in 1 day
(7 Reviews)
4.1
jsb1156

Experienced project professional, US based, MBA, EXCEL and MS Project expert; also experienced with complex formulas, VBA, LOOKUPS, PIVOTS, and charts. I would be glad to assist with your EXCEL date formulas. Thank More

$100 AUD in 3 days
(26 Reviews)
4.3
dataEntryExperty

i will assist you in age query in excel vba or access. how much time you have?

$30 AUD in 1 day
(18 Reviews)
3.5
VirtualBrainInc

Hello, I have briefly read the description on access-query-vba project , and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well.

$250 AUD in 3 days
(1 Review)
2.8
ricardosanguines

HI GOOD DAY, I CAN DO IT QUICKLY AND PROFESSIONALLY. IT WOULD INCLUDE A FUNCTION THAT OBTAINS AGE IN YEARS MONTHS AND DAYS. GREETINGS.

$30 AUD in 0 days
(0 Reviews)
0.0
SiriusZN

Hi, This will give you the Months: DateDiff("m", #1/13/1999#, Now()) Mod 12 You will have to obviously use the correct date of birth. It does not take into account if the persons birthday has changed in the c More

$30 AUD in 3 days
(0 Reviews)
0.0
mindparcs

Hi I am not really bidding for this project. Based on your requirement i believe it should be a simple excel date based formula that you should be able to apply. Even if you google you will be able to find it. Pl. r More

$30 AUD in 3 days
(0 Reviews)
0.0