Totals in a query-based report

[babylikesburgh]

Hi everyone! So I have a week and a half left in my bachelor's degree and, busy as I am, I'm stumped on a seemingly simple Access control. I'm an online student, and I'm having a bit of trouble hearing back from the professor. So I'm here for a lil boost In my report, it lists two categories and gives totals for those categories. Now I want to get a total of the two categories, but I can't get it on its own footer. As of now, it prints in two places, below each category total. If I use the page footer, I get an error message, so I assume I can't use it there (been a long time since I've used Access, and we didn't get much practice). I've tried messing with the grouping to add a new group, but then everything repeats, BAH! I'm getting stressed trying to continue aimlessly, so does anyone have a suggestion? I'm attaching a Word doc with 2 screenshots - one in design mode and one in layout mode. You'll see what I mean. Thanks a bunch!

Attachment 712

[MAF4Fam6]

Try the following in your Text Box's Control Source:

=DCount("[PKorFKFieldNameInRecordSource]","RecordSourceQueryName")

Change the two different areas (above) accordingly.

-RC

[babylikesburgh]

How do I get it to show up only once, below the last category total? That's my problem, knowing where to put the total field by itself in that spot. Thanks!

[babylikesburgh]

Nevermind - I figured it out. I placed it in the report footer, insteads of page footer, and it worked perfect Thanks again for your reply! I figured it was something super simple that I was complicating.

[MAF4Fam6]

Sorry...just got back.
Glad you were able to work it out.
You're welcome!

-RC