Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

 Home > Courses > Access > Expert > X26 > X26 Outline < X25 Outline | X27 Outline >
 Access Expert 26 01. Math Functions 1 (27:09) Abs - Absolute Value Sgn - Sign Postive, Negative, Zero Round Banker's Rounding Round to Evens Don't Want Banker's Rounding Round to Nearest Multiple Int - Round to Integer Fix - Negative Int Rnd Up Cint - Convert to Integer Val - String to Number Val to Convert HEX to DEC Remove Thousands Separator Power of Tens: 2E14 02. Math Functions 2 (12:16) Sqr - Square Root e - Euler's Number Mathematical Constant Exp - Exponential ^ Number to Power Log - Natural Logarithm Calculate Log of Any Base 03. Math Functions 3 (11:40) Calculating PI Inverse Functions Missing Degrees to Radians Radians to Degrees Sin, Cos, Tan, Atn Calculate Building Heights 04. Math Functions 4 (29:21) Mod - Modulus \ - Integer Division Is Number Divisible By X Rnd - Random Numbers Dice Roller Form Reroll Button Requery Macro Command Display Random Records Open a Random Customer Semi-Random Customer Codes 05. Type Conversion (9:42) CBool - Boolean CByte - Byte CCur - Currency CDate - Date CDbl - Double CDec - Decimal CInt - Integer CLng - Long Integer CSng - Single CStr - String CVar - Variant