>>
>>Thank you for clarifying. Sorry that I didn't pay attention to the semicolons. I will test this approach in both VFP and SQL Server. Initially I thought I would do it using a Function (with pretty much similar code that you wrote). But view is probably better approach (although I don't yet understand why).
>
>
>> But view is probably better approach (although I don't yet understand why).
>
>
>I think it is because a view is faster.
>
>btw - I have used nvl() in case there are no invoices yet. I think the sqlserver equivalent is ISNULL()
http://msdn.microsoft.com/en-us/library/ms184325.aspxThank you for the NVL() and ISNULL() explanation.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham