Query expression to add data

[Tony Williams]

I have a table with two fields txtmonth (date field) and txtamount
(integer0. txtmonth contains quarterly dates over a period of 10 years eg
31/03/04, 31/06/04, 31/09/04 and 31/12/04 etc. I want a query that adds the
value of txtamount for 31/03/04 to the value of txtamount for 31/06/04 and
then the value of txtamount for 31/03/04 to the values for 31/06/04 and then
the value of txtamount 31/03/04 to the values for 31/06/04 and 31/09/04 and
so on for the 10 year period.
Can anyone suggest a possible solution?
TIA
Tony

 

[[MVP] S.Clark]

Using VBA code, you could write a proc to handle the calculation. Query
wise, you could probably, with enough patience, and lots of spare time,
figure out a way to string together several (or hundreds) of queries to make
the desired calcs. I don't know the depth of the data, so it may take 5
minutes, may take 5 days(or more)
..

 

[Guest]

Thanks for that I suspected as much could you point in the right direction
for VBA code I'm a novice at that?
Tony