423,846 Members | 1,959 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,846 IT Pros & Developers. It's quick & easy.

Create Report Using Multipe Tables

P: 3
I'm not a programmer so thanking in advance for detail explanation. I got couple of personal budget tables showings expenses at different dates eg; groceries,Eat Out, General expenses etc. I'm using Access 2010.
Question; how do I combine these to create a query or report to show total spending for the month? Thanking in advance.
1 Week Ago #1
Share this Question
Share on Google+
4 Replies

Expert Mod 2.5K+
P: 2,703

My best advice would be to combine all the tables into one: tblExpenses. There should be no need to split out tables by the type of expense.
1 Week Ago #2

P: 3
I keep tables separate to as to able to monitor each category of spending.
6 Days Ago #3

Expert Mod 2.5K+
P: 2,703
I understand why you want to keep them separate, but there is no need to. If all transactions are in one table, you have a field that identifies the type of transaction: Groceries, Eat Out, General expenses, etc. This is basic, tried and true, foundational database design. Trying to manage multiple tables that simply contain different data multiplies your headaches.

And, with one table, you can very easily build report that separate out the different types of expenses. Although "you can do it" using multiple tables, it is much more challenging.

Hope this hepps!
6 Days Ago #4

Expert Mod 15k+
P: 31,121
It seems clear that you need to get a handle on Database Normalisation and Table Structures. Without this understanding, and a design that takes advantage of this understanding, you will only ever go from one problem to another.

There are very good reasons why keeping like objects in a single table is advised.
6 Days Ago #5

Post your reply

Sign in to post your reply or Sign up for a free account.