T
Tim
Is there any SIMPLE way for a query to subtract the values of one record from
another? Can the value be calculated in a field in the query. Such as
Difference 1, Difference 2, etc?
I want to take the latest 2 dates and subtract the less recent from the more
recent.
PLEASE HELP! This is driving me insane!!!
(e.g.)
Date Field 1 Field2 Field3 Field 4 Field 5
Dif 1 Dif 2
1. 10/01/06 10 8 10 10 10
4 2
2. 09/15/06 6 6 6 6
6 2 2
3 09/01/06 4 4 3 2
3
Thanks!!!
another? Can the value be calculated in a field in the query. Such as
Difference 1, Difference 2, etc?
I want to take the latest 2 dates and subtract the less recent from the more
recent.
PLEASE HELP! This is driving me insane!!!
(e.g.)
Date Field 1 Field2 Field3 Field 4 Field 5
Dif 1 Dif 2
1. 10/01/06 10 8 10 10 10
4 2
2. 09/15/06 6 6 6 6
6 2 2
3 09/01/06 4 4 3 2
3
Thanks!!!