Hi there,
I am working on a financial report access database and try to automate the reporting procedure. I have some problems and hope you can help.
So I have 4 tables: Data, Cost Center Structure, Cost Element Structure and Period.
In Table Data, I have CostCenter, CostElement, Data, Month, Year, Type. They are from SAP accounting system, they can have data of 2016 actual expense and budget for every month; data in 2015. The table looks like:
In Table Cost Center Structure, we have the name of the costcenter, the group for different cost centers, and they have different level of grouping.
In Table Cost Element Structure, we have cost element grouped. Sometimes they only need to be sum up as revenue or expenses, sometimes they are in more detailed group.
In Table Period, we have Apr as the 1st month of our fiscal year, and it helps to sorting.
What I want, is a form with two combo boxes, so the user would choose which cost center, and which month. And generate a report of this cost center on chosen month, like:
I used a query, say query 1, to connect financial data with element, and sum up the data. Another crosstab query on query 1 to show data for 2016 Act and 2016 Bud. I have also built a form with two combo boxes, let the user chose month and cost center.
But when I run the query, it wont work. It says the query is bigger than 2G or do not recognize the Criteria I embedded in the query to connect with combo box.
I want to know if my methodology is correct. Is there any more direct way to do that?
I am new to Access, and I really appreciate your help!
Thanks,
Luna