Hello Sunshine,
>The report has 3 columns, life to date, year to date, and month to date.
Determining the date ranges for those three criteria is relatively simple, but with no date field to compare against, there is no way to calculate the numbers you are asking for.
I think you need to restate your challenge, and include more details.
HTH,
Randy Bosma
VFP - Because life is too short to code in something else...