Viewing 5 posts - 1 through 5 (of 5 total)
cheers.
March 11, 2003 at 5:22 am
#450784
I've just had a thought.
Can I add up all the columns and select them as 1 column, such as 'SELECT (col1 + col2 + col3....) AS RentTotal FROM Rent WHERE...
March 11, 2003 at 5:10 am
#450782
I think its the (col1 + col2 + col3) that I need.
Thanks for your help.
Sam.
March 11, 2003 at 5:02 am
#450777
Do you mean using SUM(col1+col2+col3) is almost instant?
March 11, 2003 at 4:55 am
#450775
Sorry, the nested loops are nothing to do with the SUM function. I need the 3 loops to 1)get the account, 2)generate rent, 3)add invoice.
It's just that when executing...
March 11, 2003 at 4:48 am
#450773