Visit our new web pages
We have launched a new extended set of web pages at www.alvechurchdata.co.uk. These old pages will stay on the server because people still have links to them but they will not be updated.
The new version of this page is at www.alvechurchdata.co.uk/hints-and-tips/accnumber.html.
![[Alvechurch Data Home Page]](images/weblogo.gif "Alvechurch Data Home Page")
Home
About us
Development
Training
Support
![[MCP logo]](images/smallmcp.gif "Microsoft Certified Professional"){kind=small}
![[BCS logo]](images/smallbcslogo.gif "British Computer Society"){kind=small}
Access Numeric Functions
This list gives a brief description of the most useful functions to manipulate numbers in Access.
Note that functions are always followed by a pair of brackets even if - like Rnd() - there's nothing in them. The Access editor will sometimes remove these brackets but by entering them you are telling Access that you are attempting to use a function.
| Abs(<number>) | Returns the absolute value of <number>. |
| Cos(<number>) | Returns the cosine of <number> radians. See Sin and Tan |
| e | Access does not have the value of e built in. Use Exp(1) to give e raised to the power of 1. |
| Exp(<number>) | Returns e^<number>. See Log |
| Fix(<number>) | Returns the whole number between <number> and zero. Identical to Int for positive numbers. |
| Int(<number>) | Returns the nearest whole number less than <number>. Identical to Fix for positive numbers. |
| Log(<number>) | Returns the natural (base e) logaritm of <number>. See Exp |
| Pi | Access does not have the value of pi built in. Use 3.1415926536. |
| Rnd() | Returns a random number. Use Randomize() to control the random number generator. |
| Sgn(<number>) | Returns 1, 0, or -1 when <number> is positive, zero, or negative. |
| Sin(<number>) | Returns the sine of <number> radians. See Cos and Tan |
| Sqr(<number>) | Returns the square root of <number>. Generates a runtime error if <number> is negative. |
| Tan(<number>) | Returns the tangent of <number> radians. Generates a runtime error if <number> is Pi/4. See Cos and Sin |
Other functions
Access date functions
Access logical functions
Access text functions
Hints & tips
The textbox class in Visual FoxPro 9 has a new Autocomplete
property which shows the user the previous values that have
been entered in that textbox.
Autocomplete in VFP 9
Your Access database will look more impressive if you add custom toolbars...
Custom toolbars
FoxPro has always had functions to read and write files at a low level...
Foxpro low level file functions
More...
More pages of hints and tips for users of Microsoft FoxPro and Access databases.