RE: Subtract fields accross records
- From: Wayne-I-M <WayneIM@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 21 Aug 2008 06:06:01 -0700
If you want to retreve the state of account on a previous date you will need
a table to store the "sales".
ID
Date
Linking field (to item table)
Number
If you just want to reduce the amount of items held in a certain field use
an afterupdate of an unbound field on the form.
--
Wayne
Manchester, England.
"Hold the Onions" wrote:
Using Access 2003, if you have a one table database,.
Count Date Item Amount
1/22/08 Oranges 2
1/22/08 Apples 5
1/22/08 Pears 3
1/23/08 Oranges 4
1/23/08 Apples 8
1/23/08 Pears 6
How do you calculate the change in each item from the prior date as follows,
Count Date Item Amount Change
1/22/08 Oranges 2
1/22/08 Apples 5
1/22/08 Pears 3
1/23/08 Oranges 4 2
1/23/08 Apples 8 3
1/23/08 Pears 6 3
I am trying to use dlookup to pull the amount from the prior date, but it
does not seem to work within the same table. I have found solutions to other
questions where it seems to address this, but they are more complicated than
I can understand. Thanks.
- References:
- Subtract fields accross records
- From: Hold the Onions
- Subtract fields accross records
- Prev by Date: RE: Albert Kallal's Mail Merge
- Next by Date: Combo Box
- Previous by thread: Subtract fields accross records
- Next by thread: RE: Subtract fields accross records
- Index(es):
Relevant Pages
|
