Skip to Content
0
Former Member
Dec 01, 2009 at 09:05 AM

Valid From Valid To in BEx for Account Statemnets

63 Views

Hi all,

i have a requirement for a report to display the validity of amounts meaning an account statement of the client,

In an DSO i have the following data

Calday Amount

01/12/2009 100

02/12/2009 100

03/12/2009 200

04/12/2009 300

05/12/2009 300

06/12/2009 400

So i want in a query the user to select range in days 01/12/2009-05/12/2009

and to display the folllowing

Valid From Valid To Amount

01/12/2009 02/12/2009 100

03/12/2009 03/12/2009 200

04/12/2009 05/12/2009 300

please does any one knows how this can be implemented in query designer ?