filmov
tv
How to apply or use ROUND and DateDiff formula in access
Показать описание
Hello friends, This tutorial you can learn How to apply or use ROUND and DateDiff formula in access.
Round Function:
Ms access round function returns a number rounded to a specified number of decimal places. however ,
the ROUND function behaves a a little peculiar and uses something commonly referred to a as bankers rounding.
If the expression that you are rounding ends with a 5, the ROUND function will round the expression so that the last digit is an even number.
syntax: Round(expression, [decimal_places])
for example:
Round(13.55, 1)
Result: 13.6 (rounds up)
Round(12.75,1)
Result: 12.8 (rounds up)
DateDiff: DateDiff function returns the difference between two date values,
based on the interval(explanation) specified.The interval of time to use to calculate the difference between date1 and date2.
SYNTAX:
DateDiff ( interval, date1, date2, [firstDayofWeek], [fisrtDayofYear])
FORMULA 1
DateDiff("yyyy", #15/10/1999#, #22/11/2006#)
Result : 3
DateDiff("m", #15/10/1999#, #22/11/2006#)
Result: 1
DateDiff("d", #25/11/1999#, #05/11/1999#)
Result: 20
Round Function:
Ms access round function returns a number rounded to a specified number of decimal places. however ,
the ROUND function behaves a a little peculiar and uses something commonly referred to a as bankers rounding.
If the expression that you are rounding ends with a 5, the ROUND function will round the expression so that the last digit is an even number.
syntax: Round(expression, [decimal_places])
for example:
Round(13.55, 1)
Result: 13.6 (rounds up)
Round(12.75,1)
Result: 12.8 (rounds up)
DateDiff: DateDiff function returns the difference between two date values,
based on the interval(explanation) specified.The interval of time to use to calculate the difference between date1 and date2.
SYNTAX:
DateDiff ( interval, date1, date2, [firstDayofWeek], [fisrtDayofYear])
FORMULA 1
DateDiff("yyyy", #15/10/1999#, #22/11/2006#)
Result : 3
DateDiff("m", #15/10/1999#, #22/11/2006#)
Result: 1
DateDiff("d", #25/11/1999#, #05/11/1999#)
Result: 20
0:00:25
How To Apply Retinol To Achieve The Best Results
0:07:25
How to Apply For UK Youth Mobility Visa Ballot 2025 | Live Step-by-Step Application Guide For ALL
0:00:50
Doctor Explains How To Apply Serums Properly!
0:00:30
How a dermatologist layers serums 👌🏻
0:00:13
HOW TO apply hair serum with The Ordinary Multi-Peptide Serum
0:00:44
How To Apply Denture Adhesive
0:00:56
How To Apply Caulk Easily!
0:00:41
How To CONTOUR Like a Pro in Just 5 Minutes!
0:08:49
How to apply a lipstick and how to make it waterproof | lipstick trick | matte lipstick
0:00:25
How to Apply Nail Polish Like a Pro
0:00:59
How To Apply Press Ons (EASY) #nails #howto #shorts
0:00:13
How To Apply Face Serum The Correct Way for Better Results | Skincare Tips | Be Beautiful #Shorts
0:00:17
How to apply nails with “Stickers” no glue required #shorts #nails #nailart
0:00:38
How To Apply Liquid Lipstick Like a Pro #aakankshaghai
0:00:14
Makeup eyeliner tip. how to apply eyeliner perfectly 😃
0:00:51
How to apply your fake nails using nail glue
0:00:44
I Tried Applying False Eyelashes With a Lash Curler And… #shorts
0:00:27
How To Apply A Fragrance | Men's Cologne/Perfume Review 2022
0:00:58
HOW TO: Apply False Lashes for Beginners
0:00:31
Top 5 Acrylic application mistakes‼️What mistake are you guilty of ???
0:00:13
HOW to apply retinol serum 👌✨
0:00:15
How to apply press-on Nails with glue | LÓA NAILS
0:00:20
How to glue the press on nails perfectly
0:02:10
How to apply scalp medications
Комментарии