Query Suggestion

D

DMP

Hi,
Basically I have Table Containing following format :

Slno Date DrAccount CrAccount Amount Type
-----------------------------------------------------
1 01/04/2005 Cash Rent 1000 1
1 01/04/2005 Bank Salary 2000 2
1 02/04/2005 Cash Stationary 100 1
2 02/04/2005 Cash Off. 200 1
1 02/04/2005 Bank Off 300 2

How can populate data following format :

Type(1)
Type(2)
Slno Date DrAccount CrAccount Amount Type Slno
Date DrAccount CrAccount Amount
----------------------------------------------------------------------------------------------------------
1 01/04/2005 Cash Rent 1000 1
01/04/2005 Bank Salary 2000
1 02/04/2005 Cash Stationary 100 1 1
02/04/2005 Bank Off 300
2 02/04/2005 Cash Off. 200 1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Balance (Debit and Credit) in Access 2007 3
Query showing duplicate values 2
Date Format: Year + 1 3
Running balance for debit and Credit using query in Access 2007 0
Query Problem... 1
SQL query help 6
Relateive maximum/ price value of a date 1
Taking the sum between two dates 2

Top