Cesar, you da man, this is working awesome, thanks for the tips!

Great idea, let me give it a shot. Can you add a subreport to the page footer?

Hi Cesar,

The report could be one or more pages long, I need the totals to always print at a static location at the bottom of a 8.5X11 page, on the...

Not quite, putting the sum at the table footer will insure that it prints at the end of the table, but I need to insure that the sum always prints...

Found this...

Rob,

This works awesome...and no loop...wonderful!

Thanks!

Marty

Just tried it and I'm using the function and it seems to work...although it takes a little time to run. Thanks so much for your help.

Is there a better way? I would rather not do it in a cursor.

Thank you, worked perfectly!

Just a typo Janna, didn't fix anything

That doesn't work either through the procedure, I get the same error

May just have to do that, I wasn't sure if there maybe was a system field to say when the table was last updated

Actually the error is coming from SQL Server. I pulled them all together in Crystal and it worked

Antares, I think I got it!

Create  FUNCTION dbo.PreviousLot (@Cust_ID int, @Cur_Lot...

Thanks for the prompt reply! Came up as all nulls that time