I'm fairly new to Access in the fact it's completely self-taught, and I'm not familiar with coding it. I'm needing a report to show the total of prior year transactions, then list individually current year transactions. I created a query to sum prior year, but then how do I add current year. Can I create 2 queries and merge them? It will be an ongoing year after year report, and we need to be able to pull up any year (showing prior as a sum, then current as detailed).
My fields are: Effective date, purchased units, purchase price, vendor
My fields are: Effective date, purchased units, purchase price, vendor