Financial Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having unique non static values in a table where their uniquness are
defined by cost unit, category( budget, forecast or outcome), account and
period. Now I need to present subtotals based on a range of accounts e.g.
3010-3690 equals revenue, 4010-4020 equals cost of goods sold etc. What would
be the best way going about making such a report?

Pretty new to Access so I'm greatful to detailed answers.

Best Regards / Bell
 
Create a new table that can link to your existing table and define the
ranges of accounts you want to subtotal in this new table. Create a query
that includes your data table and this new table. Base your report on this
query. In your report, group on the ranges of accounts. It's a simple matter
then to find the subtotal of each group.
 
Back
Top