Chandan,
if your tables have exactly the same structore, you should normally use only one table. Add one field c(1), and use a character to identify the account type there.
>Hello Experts,
>
>I have eight tables. Each tables have same structure which are acno,date,debit,credit and balance. The tables are used for storing the transaction details of different account head,e.g, Transport,Artisan,Business, X1,X2,X3,X4,X5,X6. I want search by date
>
>and print them through report. The report style would be as follows:
>
>Head: Date:
>Sub-Heading: Transport
>
>ACno Debit
>
>Total { Here sum of Debit will come)
>Sub-Head: Artisan
>
>ACno Debit
>
>Total Sum of Debit of Artisan
>
>---
>
>At last Sum of All sub head.
>
>Please help me . How I can proceed ?