I have a problem I'm hoping someone can help me with.  I need to include
both monthly and ytd expenses for a department expense report.  If I allow
the user to enter the period as an input parameter in order to determine
monthly expenses(i.e. period 3), how can I then get  and sum all the entries
for a department for the fiscal year(i.e. for period 1 + 2 +3)?  I'm really
puzzled by this one--any suggestions would be much appreciated.

Thanks,

Sue

Maybe I'm completely off from what you want, but it's the first idea that
came to mind.

Paul Benner

Paul,

I'm not sure I understand what you mean.  I'm not really clear about how to
separate the rows which reflect all the periods(the sum of which would be
ytd), and the rows which reflect just the particular period in
question(which would be monthly expenses).   For example, if we were in
period 5, the user would enter 5 for the period, and the sql would get all
those detail rows for which the period was 1 or 2 or 3 or 4 or 5.  Summing
the amount in these rows would give the ytd amount.  For the monthly amount
I would need to subtract those rows where the period was 1,2,3, or 4.  I
can't see how to do that in crystal(I'm not using vb).

Thanks,

Sue