Microsoft Access DatePart Function: Get Specified Part of a Date (Year, Quarter, Month, Week, etc.)

[@bahabdulrahim263]

Hello sir, i want to know how to check an employee start date to the end/current date and display the days, months and years that employee has worked/spent in that company

[@599CD]

Very similar to this: Calculate Age: 599cd.com/age

[@Kh3lKh3l]

Hi there, I have sales date in Sales table and expenses date in disbursement table, how to show 2 dates (sales: date feb.26, amount) minus (disbursements: date feb.26, amount) in report? Each day will be computed.

[@599CD]

Join the tables together in a query, perform the calculation. I'd use one table for both.

[@washington_dc]

Richard, I have a database uploaded to SharePoint, I wanna know if the storage of the tables continue the same (2gb) for all the tables together or 2 gb per table ?

[@599CD]

That's something you can Google: tinyurl.com/y75b953s

[@talokermasti]

Although consulting and befitted from your lessons for last five years, This is the first time asking you a question, please help me.
I have a date in field ,want only moth and year in next field, I done it but in the sum query it grouped with actual dates wher as I need all record with month only thanks

[@599CD]

That's what DatePart is for.

[@michaelrstahl4195]

Very useful info. Thanks

[@599CD]

Welcome