Convert F to C and Back Again, by Bilbo Baggins...

In this Microsoft Access tutorial, I'm going to teach you how to convert from Fahrenheit to Celsius and vice versa. We'll learn the equation for the conversion. I'll show you how to do it in a query, and then how to do it in a form directly, and we'll talk about some of the ins and outs of each.

Jade from Redwood City, California (a Platinum Member) asks: I get temperature readings in Fahrenheit, and I have to enter those into my database and convert them over to Celsius for one of my vendors. I know the formula for conversion, but I'm having a hard time figuring out how to store that in my database. Please help.

Members

Members will learn how to create functions in VBA to handle the conversion. We'll make FtoC and CtoF functions which can be used anywhere in our database: in queries, forms, reports, macros, other VBA functions, etc.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Calculated Fields
• Rounding

Links

• Form Footer Totals

Recommended Courses

• Access Beginner 1

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Fahrenheit to Celsius conversion, Celsius to Fahrenheit conversion, F to C, C to F, Access query calculation, Access form calculation, calculated fields in Access, using round function, converting temperatures in Access