Search results

I shall stick with mine, thank you lol

I feel so silly. Excuse me while I wear my dunce cap in the corner.

One last question!!! Mostly 'cause I just caught it. I have an employee who has been here for almost 1 year (will be the 26th) but the code gives back "0 years" instead of "11 months." How would I go about fixing that? Thank you!

I have a lot to learn! Thank you so much for your time and explaining it to me. I genuinely appreciate it. Your code also gave me exactly what I wanted as well. This has given me some insight on what to be aware of and how to improve. Thank you everyone! ❤️

Makes sense! Is that why you had Day(Date) there?

Thank you thank you!

Oh good catch. Noted! Thank you. May I ask the purpose of the "_2" in the CalcAge_2? Is it just to test as a separate Function? Could you explain this code a bit more please? Thank you! That seems simple enough. How would I incorporate this into the code? Thank you!

Ok so messy all around haha. Oops. I'm very, very new to coding. Thank you for pointing it out. Ok, so I would just need to swap the two so "months" is first?

Oh, I'm not familiar with this. If I put in Date2Diff, would I need to explain that in the code? Not sure the proper phrasing or lingo, my apologies.

Yes, that probably would help wouldn't it. intMonths = DateDiff("m", [Hire_Date], Date()) This would be it, right?

Hello! I am at my wit's end and need some help understanding on how to fix or improve a Function to implement into a query. I am trying to find how long an employee has been working at my company but expressed in either Years or Months only. Not both. For example, if an employee has been...

Hello, I can find my way around Access, but I'm still trying to learn VBA and SQL. I hope to learn more! Thank you for having me.