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 ?