Re: Calc

> >   trx_date  | trx_time |                      descriptions    |
> > payment_method | debet |  credit  | creator
> > ------------+----------+--------------------------------------+----
> >--------- ---+-------+----------+---------
> >  2003-10-09 | 21:55:02 | Resto Biling : 13,800, Paid : 10,000 |
> > Visa
> >
> > |  3800 |          | middink
> >
> >  2003-10-16 | 03:28:30 | Payment - Thank You                  |
> > Visa
> >
> > |       | 40000.00 | middink
> >
> >  2003-10-08 | 18:17:40 | Payment - Thank You                  |
> > Cash
> >
> > |       | 50000.00
>
> The id field only keeps the transactions in the correct order so you
> can sum the previous transactions. You can do the same thing with
> your date and time fields (though using a single datetime field would
> be easier). A caution, though: you will have trouble if two
> transactions share the same date and time.

if i would like to pleaced ID(Virtual ID)  for example number of record for
each record, how to ?

num_rec |  trx_date  | trx_time |  credit  |
descriptions                      | payment_method | debet
---------+------------+----------+----------+-------------------------------
-------------------------+----------------+-------      1 | 2003-10-09 | 21:55:02 |          | Resto Biling : Rp.
13,800, Paid : Rp.      10,000 | Visa           |  3800      2 | 2003-10-16 | 03:28:30 | 40000.00 | Payment
| Visa           |      3 | 2003-10-08 | 18:17:40 | 50000.00 | Payment
| Cash           |