SQL Grouping question....

[Mykiel]

I have a patient aging report (Health care - accounting/financial) that I have developed. I am querying to return data for patients with outstanding balances (I am getting all the columns of information back that I have queried). My problem is that I have grouped this data by "biller_name", the name of the company employee that physically billed each patient.

Problem: My report is printing only the information for a single biller when what I need is a single report to run for all the billers and at one time (SEE EXAMPLE BELOW). I am only getting...say biller_2_name..'s information.

Example of what I need:

xxx Header Area of Report Total 4/06 3/06 2/06
-------------------------------------------------------
biller_1_name
patient 1 data $xxxx xxx xxx xxx
patient 2 data $xxxx xxx xxx xxx
patient 3 data $xxxx xxx xxx xxx
ECT....................

biller_2_name
patient 1 data $xxxx xxx xxx xxx
patient 2 data $xxxx xxx xxx xxx
patient 3 data $xxxx xxx xxx xxx
ECT....................

biller_3_name
ECT....................


I would appreciate any assistance given.

Thank you,

-Mykiel
Jr. Access Report Developer

 

[Golom]

Looks like the query on which the report is based is constrained to returned only for a specific biller. Can't really tell though unless you post the SQL.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[ssatech]

Have you played around with Sorting and Grouping properties.

Field/Expression
Biller_Name
Biller_NameID
Patient_Data


Then your report:
Biller_NameID Header
Biller_Name Field

Patient_Data Header
Detail
Patient_Data Field

Otherwise, try posting in the Reports Forum

 

[Pampers]

A guess. You don't need the grouping clause in your query to get that result. Instead, set the grouping in your report (design view) under the Sorting and Grouping-option, and set it to BillerName.

Pampers
Just let it go...