Over the last few years I've become fairly proficient in Excel, but I recently got Access because most of what I was doing seemed more fitting for a database vice spreadsheet. I've figured out my Personal Property database, but I'm struggling putting together one for Personal Finance. Largely in part of my Excel knowledge and just playing around with Access with no guidance.
Unable to attach the small file for some reason, so in a few words...
There are four columns (sub category, item info, value, qualifier) with 25 fields under each (lookup with two columns from another table, short text, currency, short text respectively).
I would like it this way so I can enter the data itemized like it appears on an actual receipt and so there is more data to manipulate later (i.e. use the qualifier to create a report with the details that I need to add to the Property database), and I see it as more efficient to just type than think about "okay, look down the list, so these two are this, now add them, cool. damn, missed one, redo..., and repeat a bunch of times". In excel it was as simple as using the sumif formula, but don't quite see anything like that in Access.
I know it would work if I manually calculated the totals for the different categories and then entered them into their own field. But, I'm thinking there has to be a way to do it.
TIA