I have an access data base table with fields

Date Accountname Debitamount Creditamount

I want to create one day book

Date               Accountname              Debit              Credit

if date same that field shall not be repeated  as everybody know

When a new date comes creditamount-debitamount shall be shown as opening balance

any idea?

CrystalRpt:

I have an access data base table with fields

Date Accountname Debitamount Creditamount

I want to create one day book

Date               Accountname              Debit              Credit

if date same that field shall not be repeated  as everybody know

When a new date comes creditamount-debitamount shall be shown as opening balance

any idea?

if date same that field shall not be repeated in the sense if the records comes like this

Date

19/12/2009

19/12/2009

then it should show only one time right?

If my understand is correct then you can write the query like this

select distinct [date], AccountName, Debit, Credit from dbo.table1 where condition;