SQL

[dpaulson]

I have a table called Invoices. I need to create an SQL that will sum up all field data (DebitTotal) to create Balance, sum of field data (DebitTotal) that is less than 1 month old (InvoiceDate) to create PeriodOne , and so on to PeriodThree.
Can anyone give me a hint as to how this SQL would look.

Thanks
David

David Paulson

 

[johnwm]

Detail may depend on which SQL you are using:
forum436 for MySQL
forum183 for MSSQL
forum220 for ANSI SQL
forum318 for Pervasive
forum699 for PostgreSQL

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[dpaulson]

Oh, sorry. Which link is the correct one when using an access db.

David Paulson

 

[gmmastros]

forum701 for Access

Don't be too sorry. Lot's of people make this mistake. It's best to post a question in the proper forum because you are more likely to get a better response in a more timely fashion.

Read the Faq's at the end of John's post. The tips in the faq's will help you to write a better question.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ZmrAbdulla]

I think "SQL" search will return 21 forums.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.