J
Jazzy
I have written a query that performs calculations using
values taken from another table (at a particular date).
That part of the query works fine.
The problem is when I want to run the query and change the
date. I don't know a lot about programming but what I
want to do is something like "If the effective date is
(eg) 16/10/2003, then the existing records use table A.
If the effective date is 20/10/2003, then the new records
should use table B."
The problem with this is that I don't want to change the
records that I input from using table A (i.e. I still need
the "old" records to continue using Table A). I only want
the new records to use Table B.
I hope this makes sense. Can anyone help please?
values taken from another table (at a particular date).
That part of the query works fine.
The problem is when I want to run the query and change the
date. I don't know a lot about programming but what I
want to do is something like "If the effective date is
(eg) 16/10/2003, then the existing records use table A.
If the effective date is 20/10/2003, then the new records
should use table B."
The problem with this is that I don't want to change the
records that I input from using table A (i.e. I still need
the "old" records to continue using Table A). I only want
the new records to use Table B.
I hope this makes sense. Can anyone help please?