[AccessD] Getting info from a single record table

Years ago, I created a small program to track mileage of workers. There are a bunch of things I'd have done differently, but they are very pleased w/it. The bad thing though is that I couldn't figure out how to change the mileage rate, on the fly, so I hard coded it. So, I have had to go in and alter this rate, every quarter, if it changes.

This wasn't too awfully bad, but they didn't notify me, the last couple of times, until we were well into the quarter, and they had already keyed in a bunch of the entries.  The calculation is done at the time of entry, so the allowances were off, and I had to run a quick update query to fix the old amounts. This is one of the things I would do differently, and I may change it to compare the date w/a table of dates and rates, but this immediate question will be relevant for that too.

I would like to, for now at least, install a one-record table, to hold the rate in it. I would have a very small form...basically a pop-up type form...that would hold the rate. There would be no nav. buttons, so they are stuck on the one record only. But...finally, we're at my question...how do I reference this record?

Example:

Currently: [AmtOwed] = [Miles] * .485

Would like: [AmtOwed] = [Miles] * [tblMileageRate]![CurRate]

Make sense? I hope!

John W. Clark