I have a table with historical entries. First off, there is a field called DESC, text, that can be ThingA, ThingB, or ThingC (it's possible that it could be different, but those are the only three things that really matter for the sake of my question).
ThingC is a monthly thing so is structured as "January ThingC"
December ThingC
etc.
Always the month + space + ThingC for the DESC field
ThingA and ThingB are always either "ThingA" or "ThingB" respectively.
Each item has an AMOUNT field (Number, General Number, Double data type), regardless of type, as well as a DateAdded field.
I wanted to generate a report where it will total the entires for this given a date constraint by the user (txtDateFrom and txtDateTo on a form called FrmDateRangeSpec) contained in the DateAdded field (date/time data type).
For instance, txtDateFrom being 1/1/2011 and txtDateTo being 1/31/2011
It would generate a report that would only show the total number and total amount of entires for each one (given they are within the date constraint mentioned above by their DateAdded fields). Individual entires (since tehre will be a lot of them) are irrelevent since I just want the totals for the types of entries.
------------------------
EX.
Number Type Amount
2 ThingA $2.15
65 ThingB $13513.13
0 ThingC $0
-----------------------
It would ideally remove the month from the front of the DESC for ThingC (just saying ThingC instead of saying January ThingC) on the report.
The names for the actual things (ThingA, ThingB, ThingC) will not change(case, space, or otherwise).
I found this:
https://www.accessforums.net/reports...port-9073.html
Which is basically the same question I'm asking, but I uh... don't really understand what he means :\
Is he talking about on the report grouping, the advanced option that says "Keep whole group together on one page?" If so, how would that account for the ThingC? If it wasn't really possible to seperate the names of ThingC, then I would be completely okay with just leaving January ThingC and February ThingC as two seperate entries (groupings?).
I hope this question is clear (feel free to ask if I'm just talking in circles), and as always I appreciate any help you guys are willing to offer!
Thanks!
Edit: In my example those things above were all neatly spaced out like the fields headers/data on a normal Access report T_T
It would also be helpful if it was in the VBA part of it (since I still remain totally lost with the built-in Access Queries), but beggars can't be choosey as the saying goes