Hi Bob,

There are three row fields,

product, transaction date, transaction no

and three data (sum) fields, receipt, issue and balance which is a
calculated field shown as running balance with base field of
transaction date (receipt - issue)

product: hydrochloric acid
               date: 4/1/2007
                                  transaction: opnbal

40                      0                            40
               date: 4/2/2007
                                  transaction: inv/1
0                      20                            20
               date: 4/3/2007
                                  transaction: purchase/1
10                     0                             30

product: sulphuric acid
                date: 4/1/2007
                                  transaction: opnbal

10                     0                            10
                date: 4/1/2007
                                  transaction: purchase/1
15                    0                              25

so running balance (the last data field) has to have base field of
transaction date, but instead of showing me the running balance values
in the above way.........excel shows me #N/A

thanks......

regards,
shripal dalal.

bob,

i am sorry i forgot to write the field names in the last message, the
first three row fields are: product, transaction date, and transaction
number

and the numbers are qty rec, qty iss and balance (which is a
calculated field running total with base field of transaction date)

I just dont know how to do the formatting in google. it's a nightmare
to format plain text messages.

regards,
shripal.