|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 4th, 2006, 05:12 PM
posted to microsoft.public.access.queries
|
|||
|
|||
calculated field
I am trying to create a formula that will take the day before value and add
it todays value...and continue to calculate for the previous day. -- Marion Bynoe 
|
|
#2
October 4th, 2006, 08:50 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
calculated field
How many days do you want to total? Your statement looks like a mimimum of
three days. If that is it then in a totals query use this as criteria on your date field. Between Date()-2 And Date() "mbynoe" wrote: I am trying to create a formula that will take the day before value and add it todays value...and continue to calculate for the previous day. -- Marion Bynoe
|
|
#3
October 4th, 2006, 10:48 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
calculated field
KARL DEWEY wrote:
How many days do you want to total? Your statement looks like a mimimum of three days. If that is it then in a totals query use this as criteria on your date field. Between Date()-2 And Date() I am trying to create a formula that will take the day before value and add it todays value...and continue to calculate for the previous day. Hi Karl, Thanks for your assistance! -- Marion Bynoe
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
