Running totals in queries?

[Tony Williams]

I have a database that hold s figures for each quarter. I want to create a
query whereby the user can ask for the running total of the data upto the
quarter they enter into a prompt. The database stores the quarter name in
txtmonthlabel (a date field) and the quarters totals in txtdomic (a number
field) EG If the user enters March 2004 they get figures upto March 2004, if
they enter June 2004 they get total upto June 2004, in other words the query
would add March's figures to June's figures to give the totals, not just
show June's figures.
Can this be done in a query and what would the prompt criteria be?
TIA
Tony Williams

 

[[MVP] S.Clark]

If data is stored as just dates, then you can use the Between...And
construct.

If data is stored as YYQQ, 0401, then you may be able to prompt the user for
the max YYQQ.

If data is stored as MMMYY, MAR04, then you have much work to do.

 

[Tony Williams]

Steve, the data is stored as mmmmyyyy do I have a problem?
Tony