[AccessD] Getting info from a single record table

John,

I would do a table with the effective date range for the mileage rate.
You do a quick select for the date of the entry to see where it falls
in the range and get the rate for it.  Now, it is fixed forever, and
you also have the history of the rate. It is a good fix, and not just
a Band-Aid.

Robert


At 10:09 AM 4/17/2007, you wrote:
>Message: 1
>Date: Mon, 16 Apr 2007 14:44:49 -0400
>From: "John Clark" <John.Clark at niagaracounty.com>
>Subject: [AccessD] Getting info from a single record table
>To: "'Access Developers discussion and problem solving'"
>         <accessd at databaseadvisors.com>
>Message-ID: <46238BDD.167F.006B.0 at niagaracounty.com>
>Content-Type: text/plain; charset=US-ASCII
>
>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