424,035 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,035 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.
Dec 2 '18 #1
Share this Question
Share on Google+
4 Replies


twinnyfo
Expert Mod 2.5K+
P: 2,775
mustaqalifj,

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.
Dec 3 '18 #2

P: 3
I keep tables separate to as to able to monitor each category of spending.
Dec 7 '18 #3

twinnyfo
Expert Mod 2.5K+
P: 2,775
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!
Dec 7 '18 #4

NeoPa
Expert Mod 15k+
P: 31,160
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.
Dec 8 '18 #5

Post your reply

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