I want to display years, months and days since a certain date. I can show total days or months or years but can't seem to get all three like "20 years, 7months and 14 days"
Scott Axton
@Reply 4 years ago
We need you to go back to high school and "Show us your work"
Its really hard to help diagnose what is the issue when we don't know what you have done.
Thank you Alex and Scott very much. The images show what I am trying to do. I can get # of days, # of months, and #of years but I want it to display "21 yrs, 3 months, 14 days". I am not great with this so explain like you're talking to an idiot (you are).
Again thank you for helping me out
Aubrey
Kevin Robertson
@Reply 4 years ago
Create new calculated fields in your query for Years, Months, Days. Then a final field to concatenate all three values together with the appropriate text.
Kevin Robertson
@Reply 4 years ago
Aubrey JohnsonOP
@Reply 4 years ago
I don't understand Kevin. Wouldn't that give me total time in each calculated field? What I need is full years, with months being a partial year in months with some days left over. Like 21 yrs, 4months and 12 days.
Kevin Robertson
@Reply 4 years ago
My screenshot shows this. Are results in the last column not what you are looking for?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.
