Create Custom Function - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Create Custom Function

David Clement

4 years ago

I recently watched the Create Customer Function video where Richard showed how to do a Celsius to Fahrenheit/Fahrenheit to Celsius Conversion on a form.

I was wondering if there is similar formula for Feet to Meter/Meter to Feet. I have tried to find a formula but can't seem to find one.

Any help would be awesome!
Thank you.
Dave
P.S. kilometers to miles and miles to kilometers could be helpful too.

	Kevin Robertson @Reply 4 years ago
Below is a sample from my database which includes the formulas you mentioned. Hope this helps.

	Kevin Robertson @Reply 4 years ago

	Richard Rost @Reply 4 years ago
It's all just multiplication.

	David Clement OP @Reply 4 years ago
I'm sorry, not quite sure how to write this out as a custom function. Your Celsius/Fahrenheit-Fahrenheit/Celsius worked GREAT! Trying to make a "Utilities" Menu for these other conversions. I have never been good at math/arithmetic.

	David Clement OP @Reply 4 years ago
Thank You!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View