Compare budget to actual figures in a account

A

Albert

Hi Guys,

I have drawn a blank. Please help?

I have a table which affectively are all items from my bank statement.

I would like to then to compare my budget against the actual but I have my
budget setup in a cross tab table (categories in the rows and months in the
columns)

How can I set the database so that I can query the sum of categories bewteen
2 dates and the comapre it to the budgeted figues corresponding to the dates?

Thanks
Albert
 
J

John Spencer MVP

You would need to normalize your budget data into a structure that like
Category (text field?)
PeriodStart (Date field) first of month
PeriodEnd (Date Field) End of month
Amount (Currency field)

Are there multiple years involved in the actual and in the budget tables or
just one year?


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare budget to actual 1
allocated vs unallocated budget 1
Listing out Budget, Actual and Forecast 4
MSP - Budget Vs Expense 0
Query to Compare Actual and Budget 1
Pivot table to calculate variance showing budget and actual. 3
Joining a Budget and Actual Table 3
Compare Planned to Actual monthly payments 1

Top