Access: Tan Function

In Access, the Tan function returns the tangent of an angle.

The syntax for the Tan function is:

Tan ( number )

The argument number can be any valid numeric expression that expresses an angle in radians. Tan takes an angle and returns the ratio of two sides of a right triangle. The ratio is the length of the side opposite the angle divided by the length of the side adjacent to the angle.

Tan (15)     returns -0,855993400 
Tan (2)      returns -2,185039863

VBA Code

Dim MyNumber 
MyNumber = Tan(2.5)

This example uses the Tan function to return the tangent of an angle. Now the MyNumber variable would contain the value -0,747022.

SQL query

You can also use the Tan function in a query.

SELECT Tan([OwnerId]) AS Expr1 
FROM Orders


Leave a Reply

Your email address will not be published.