Search results

I have some data in the same format as the Raw Data table in the attached file, and I need to change it into the same format as the Desired Format table. So it's a list of account numbers and credit note details; and I need to have the credit notes for each customer on one line per account...

I've got some data that's in the format of:- Account No. | Credited Date | Credit Amount | Credit Note Number 123456 | 01/04/2012 | 100 | 3000123 123456 | 05/04/2012 | 200 | 3000124 654321 | 01/04/2012 | 100 | 3000125 456789 | 01/04/2012 |...

Hoping someone can help me with this; I have a file which shows inventory levels submitted every Monday, along with sales between each week. I need to be able to create a query so that someone can enter a start and end date and they will be shown the difference between the opening and closing...