Variable Tax-Rate

[IProgrammer]

I am trying to create a query that reads 2 tables. One table contains dated transaction amounts and the other contains dated tax rates. I want to create a list that shows me the tax rate applicable on the date of the transaction.

Here are the tables:
Transaction-Date, Transaction-Amount
1-Jan, 100
2-Jan, 20
3-Jan, 300
4-Jan, 170
5-Jan, 60


Tax-Effective-Date, Tax-Rate
1-Jan, 7
4-Jan, 8

This is what I am looking for as a result:

Transaction-Date, Transaction-Amount, Tax-Rate
1-Jan, 100, 7
2-Jan, 20, 7
3-Jan, 300, 7
4-Jan, 170, 8
5-Jan, 60, 8

HELP WILL BE GREATLY APPRECIATED.

 

[SkipVought]

Hi,

First of all, I see no DATES; rather strings resembling dates without the year. If you do not have REAL DATES, which are actually numbers that you can do math, you have a problem with your data.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[IProgrammer]

The dates are stored as full dates MM/DD/CCYY, this is just an example of the dates as shown in short date format copied from an excel sheet. Did you have any suggestions?

 

[SkipVought]

So do you want to do this on an Excel sheet of via a query?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[IProgrammer]

Using a MS Access Query