I Hate Reports, Its why I have put off really learning them up tell now.
anyway I started with a simple qry of a savings account. the qry_Savings when run shows
DepYear DepMonth SumOfDeposit 2019 Nov 25.00 2019 Dec 25.00 2020 Jan 25.00 2020 Feb 25.00 2020 Mar 25.00
The qry Design view is pulling the year and month from the actual deposit date if that makes sense
when I create a simple report (using the wizard)
DepYear DepMonth SumOfDeposit 2019 Nov 25.00 25.00 Jan 25.00 25.00 2020 25.00 25.00 25.00
Now I am not a complete Idiot, I have completed a 16 hour online course on Access, Designed some complex forms and have even jumped into some basic to intermediate VBA.
But this is just madness, voodoo magic that I cant wrap my head around. and its not just this from, its always. I am completely lost as to why it shows in this format, Any thoughts or explanations are appreciated.
thanks for your time