Grouping Issue

[Rebeca]

I'm having a problem with grouping and totals.

I have a form that the users select a date range and a report type and have
the option to select one or more physicians which then displays a running AR
total for the physician. If the user selects one physician it works properly.
If they select more than one, the beginning and ending AR balance of the 1st
physician in the report is added into the running AR of the second physician
and so on.

I know that it is a grouping issue but unsure of what could be the problem.
Ideally, I think it would work if we were able to enter a section break
rather than a page break, is this even possible? I think my other option
would be to use Sub-reports but I'm not familar with them. Am I even on the
right track?

Thank you!!!

 

[KARL DEWEY]

Open report in design view, select Grouping And Sorting and use physician
field to group.

 

[Rebeca]

Thank you, but it is grouping by physician and batch date. I should have
mentioned that, sorry.