link issues

[melisc]

Hello,

I have a functioning Access database that is used by a vendor for the input of the receipt information. From that I numerous queries running off of other queries in order to create the necessary reports.

I have ran into a programming issue with this now. The tax rate for one of the counties has changed. I have this set up so that the query is linked to the location, which is linked to the tax rate. I did this so that on the form the tax rate would self populate. Now if I go into the tax rate table and change the tax rate it changes all of the tax rates for that county past and present.

How can I make this so that it only changes the tax rate going forward...is there a way to that.
Thanks for any info on this!
Melis

 

[PHV]

I suggest adding a StartingDate column in your tax rate table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[melisc]

How would I put that condition into the query - bring the start date field into the query and have the tax rate populate based on the date ranges?

Any ideas on the logic involved in that?

 

[PHV]

The easiest way is to add also an EndingDate column (despite breaking some normalization rule) and then add something like this in the query:
WHERE ...
AND receipt.date Between [tax rate].StartingDate And [tax rate].EndingDate
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244