total amounts between two dates

brend...@perth.dialix.com.au (Brendan Tibbs)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

total amounts between two dates

If any kind person could help a newbie to calculate an amount between two
dates I would be very gratefull..I'm using dbase, a one to many setup..
one client many payments.Every works fine(thanks to the data wizard setup)
but to finish off with the above feature would be great!!
Tia,
Brendan

Glatzfam

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:total amounts between two dates

You can use a TQuery object and select it in using SQL. The following example
is using the DBDEMOS database that comes with Delphi C/S:

select sum(itemsTotal) from orders
where
SaleDate >= '4/12/88' and
SaleDate<='5/25/88'

Now if you have to do a join you would do something like this:

select sum(a.itemsTotal) as total, b.company from orders a,
customer b
where
a.SaleDate >= '4/12/88' and
a.SaleDate<='5/25/88'
and a.custno = b.custno
group by b.company
Hope this helps

Other Threads

1. Q: Getting total amount of memory

2. Indy: total amount of bytes to send

3. TQuickreport: Total amount of pages

4. How can I compare two dates in two different coloumns in SQL with ADO components

5. total field of two sub tables with SQL

6. HELP NEEDED WRITING TOTALS TO GRAND TOTALS

7. Calculated Totals of Calculated Totals

8. Sub-Total and Grand Total

9. Number of days between two dates?

10. HOW 2: Count days between two dates