Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make a query for natural logarithm calculation?

Status
Not open for further replies.
jyvu

jyvu

Technical User
Dec 21, 2001
12
US
Could you show me how to create a query that will calculate the natural logarithm of one column in Access?

Thanks,
JV
 
Sort by date Sort by votes
The following is a simplified query that returns the natural log of the value in the field named Field1


SELECT Table1.field1, Log([field1]) AS Expr1
FROM Table1;
 
Upvote 0 Downvote
It works. Thanks you very much.
JV
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
438
Zyborg
Zyborg
Moss100
  • Locked
  • Question
Make database appear as just a form
Replies
1
Views
220
dhookom
dhookom
Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
441
Moss100
Moss100
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
372
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top