Programming vs Query

[willitheowl]

Hi Group,

I have a problem and I don't know whether it is better solved via a
query or a bit of VBA programming. Given a table T with fields DATE and
AMOUNT and I want to create one other table O containing for each DATE
(except the smallest) from T the DATE and the difference from that
DATE's amount and the next smaller DATE's amount. And I want still
another table S which contains for each DATE the DATE and the sum of
all AMOUNTs for that DATE and all the smaller DATEs.

I can image how to do the first one with a query that contains TABLE
twice, but for the second one I don't have an idea.

Can you give my an hints or advice from experience?

thanks,
Robert

[Ed Robichaud]

Two comments on your request:

"Date" is a reserved word in Access/Jet. You'll need to reference it as
[date] or better yet, rename your field.

Storing calculated results is almost always not a good idea. Rather,
perform the calculation in your query/form/report whenever needed. There is
little/no performance penalty and your results will never be stale or out of
sync.

-Ed
<wi*********@gmail.comwrote in message
news:11**********************@q2g2000cwa.googlegro ups.com...

Hi Group,

I have a problem and I don't know whether it is better solved via a
query or a bit of VBA programming. Given a table T with fields DATE and
AMOUNT and I want to create one other table O containing for each DATE
(except the smallest) from T the DATE and the difference from that
DATE's amount and the next smaller DATE's amount. And I want still
another table S which contains for each DATE the DATE and the sum of
all AMOUNTs for that DATE and all the smaller DATEs.

I can image how to do the first one with a query that contains TABLE
twice, but for the second one I don't have an idea.

Can you give my an hints or advice from experience?

thanks,
Robert