Alternate Records in Report Based on Query

[mizenerman]

Hello,

I have a report with a query control that resembles the following output:

Location AppleCount OrangeCount CherryCount

Florida 3 5 2
Texas 4 9 1


The report needs to read as:

Florida Apple Count - 3
Texas Apple count - 4

Florida Orange Count - 5
Texas Orange count - 9

Florida Cherry Count - 2
Texas Cherry count - 1

When formatting the report the records are grouped together based on the location and appears as:

Florida Apple Count - 3
Florida Orange Count - 5
Florida Cherry Count - 2

Texas Apple count - 4
Texas Orange count - 9
Texas Cherry count - 1

I've attempted manipulating the grouping/sorting of the report but I keep missing. Is there an idea as to how to resolve this?

Thank you in advance for your assistance.

 

[PWise]

normalize your date

State Fruit Count

 

[mizenerman]

Perhaps my problem discription didn't focus enough on the formatting of the report rather than the data structure. This is the actual data structure:


Procedure ProcCount AvgColToComp

Diff 1200 29.98
Hemogram 1303 17.82

How it appears in the query is what is being requested of me to put into a report. Is what I'm being asked possible?

 

[mizenerman]

Disregard. I found a solution using joins in queries.