Retrieving weekly totals from MSAcces

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zumbar@b00mb0x.org - 13 Mar 2006 12:52 GMT

hi,
I am writing a java application that connects to a MS Access databse
with two fields , Date and amount. I can insert into this datbase
using the application.
Now , I need to retrieve weekly totals(of the amount column) from the
database. I have no idea how to start this .
Can anyone help?
Thx

Reply to this Message

salad - 13 Mar 2006 18:02 GMT

> hi,
> I am writing a java application that connects to a MS Access databse
[quoted text clipped - 4 lines]
> Can anyone help?
> Thx

Can your Java appliation pass/run a SQL statement and return the rows?

A function in Access is Format(). It's possible to return the work
number. Ex:
? format(date(),"ww")
11
This is the 11th week of 2006. So you may want to group by the week
number if you want multiple weeks in the SQL statement.

You can filter on a date range and maybe group by year, week and sum on
the amount in the SQL statement.

Reply to this Message