Rabu, 31 Desember 2014

[MS_AccessPros] Query design question

 

Hello group,

We use one Excel table to track family expenses. Five columns: date, expense, category, sub-category, expense.

I would like to summarize them now and to be able to see the totals by categgory and sub-category where they exist (e.g. there is only 'food' category, but several sub-categories like home/gas, home/electricity, etc.).

Is it possible to create a report in Excel? If not, how is this done in Access? I imported the table into Access and attempted to design a report, but failed.

What's the best/simplest way to proceed?

Thanks, and a very Happy New Year!

Boris


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar