I am trying to create a very custom report for a accounting program I am working on, and I am having great difficulties.
The report needs to look like this:
Reciept Date Payee PO Number Reciept Total Account Acccount Account Account.....
As you can see it is breaking reciepts down into the amount spent for each expense account.
Each line in the data base looks like this:
Reciept ID Quanity Description Account UnitPrice
I then do a cross tab query to get all the data into a line format with each account that has a expense in it accross the top (colums). This is where I start to run into some trouble.
I run a second query on the cross tab query to sum each account for each recipet. If a new account is added for a new reciept this second query does not get the new colum because it is not in the query. I then build a report off of this query.
What I need is a report that will change for each time I run it. It must be able to add or delete accounts from the report so that it looks neet and there are no blank accounts.
If you have any ideas on how to do this or if you need more info from me please let me know.
The report needs to look like this:
Reciept Date Payee PO Number Reciept Total Account Acccount Account Account.....
As you can see it is breaking reciepts down into the amount spent for each expense account.
Each line in the data base looks like this:
Reciept ID Quanity Description Account UnitPrice
I then do a cross tab query to get all the data into a line format with each account that has a expense in it accross the top (colums). This is where I start to run into some trouble.
I run a second query on the cross tab query to sum each account for each recipet. If a new account is added for a new reciept this second query does not get the new colum because it is not in the query. I then build a report off of this query.
What I need is a report that will change for each time I run it. It must be able to add or delete accounts from the report so that it looks neet and there are no blank accounts.
If you have any ideas on how to do this or if you need more info from me please let me know.