Statment Query

  • Thread starter Thread starter lez
  • Start date Start date
L

lez

Hi Guys,

I am looking to create a statement that gives current totals in 30 60 90 90+
days and wonder if anyone has any tips on the best method of doing this?

Thanks
Lez
 
Give an example of what you mean - what does your data look like and what you
want the output to display.

Maybe you need the function Partition. This data is grouped in 5-day blocks.
Date Group SumOfx
07/22/2005 : 07/26/2005 13
07/27/2005 : 07/31/2005 24
07/28/2003 : 08/01/2003 4
08/06/2005 : 08/10/2005 3
08/26/2005 : 08/30/2005 21
 
Hi Guys,

I am looking to create a statement that gives current totals in 30 60 90 90+
days and wonder if anyone has any tips on the best method of doing this?

Thanks
Lez
Click to expand...

Not without some knowledge of the nature of the data that you're
totalling, no.

What's your table structure? What do you mean by "in" so many days?

John W. Vinson[MVP]
 
Sorry John, maybe a bit more clarity would be helpful

My Table orders stores date of order [df1] and value [amt] amongst other
fields, but these are the only two required here

I want to be able to sum [amt] that are 30, 60 and 90+ days of [df1]. So if
we have a number of invoices that are 30 days older than df1, I want the sum
of [amt] etc

I have a statement routine that shows all thee invoices outstanding and
would like this as a footer section to summarise the outstanding values for
each period.

HTH

Lez


Hope that helps
 
Back
Top