I am fairly new to access. I have been tasked to make a financial db which will output to excel. I have raw data grouped in tables by Accounting period.
I have made a union query to select the info from all of the periods which totals the amount and groups against the spending code.
I then have a cross tab query based on the union query to layout the information in the best possible view with the spending codes as row and periods as columns.
I now want to output the results of the cross tab (refreshing everytime i run the query) into a new table which i can import into excel.
the main problem i am having is that i have to add a "Comments" column in between every period, this is to allow us to comment on any changes month to month. The problem has been when i update the table the comments are lost or (in excel) they become disjointed to the correct spend code.
I guess that if i could have the new table so that each period will update accordingly without deleting, changing or disjointing the comments columns.
sorry if i have babbled but this thing is starting to drive me mad, any help at all would be greatly appreciated.
I have made a union query to select the info from all of the periods which totals the amount and groups against the spending code.
I then have a cross tab query based on the union query to layout the information in the best possible view with the spending codes as row and periods as columns.
I now want to output the results of the cross tab (refreshing everytime i run the query) into a new table which i can import into excel.
the main problem i am having is that i have to add a "Comments" column in between every period, this is to allow us to comment on any changes month to month. The problem has been when i update the table the comments are lost or (in excel) they become disjointed to the correct spend code.
I guess that if i could have the new table so that each period will update accordingly without deleting, changing or disjointing the comments columns.
sorry if i have babbled but this thing is starting to drive me mad, any help at all would be greatly appreciated.