Design help

[Newby]

I'm currently using Access to warehouse my financial reporting data, and use Excel for actual financial reporting. I would like to develop a more complete Access solution. Compiling some of the statement appears to be straight math, but calculating variances and ratios to include in reports and forms have me complexed. Am I trying to make a square peg fit into a round hole?

Activity - Year - BusUnit - GL code - Jan Feb ... Dec
Plan 2013 Cars


Actual 2012
Fcst9-3 2012
Actual 2011

[June7]

Why are you 'complexed'? Exactly what is the issue you have encountered? You don't know the formula?

Are you trying to describe table structure? Doesn't look like a normalized relational database design.

Review 'sticky' thread tutorials at http://forums.aspfree.com/microsoft-access-help-18/

[Newby]

Thanks you your response. I am currently having difficulties framing my question(s). When I can frame it better, I will bounce back. Thanks again.