[7omislav]

I have a table with fields: NAME, TYPE, SCORE and GENDER
I want to make a report grouped on TYPE and on GENDER but the catch is: I want GENDER to be beside each other (for example GENDER:Male on the left and GENDER:Female on the right)
I hope I explained it good enough...

[rbalaji]

You need a cross tab query. The access query builder wizard should be able to handle it quite handily. If you get stuck, post back.

[7omislav]

Sorry that's not what I want
I need to get from



to

[slurpee55]

Well, a way that will work - albeit a rather messy way - would be to first build two queries, one showing males and one showing females.
Then create two subreports based on each one of those - basically, a female report and a male report.
Finally, create a master report and insert the two subreports into it.

[rbalaji]

I thought you wanted some kind of consolidation (types down the side and gender across the top) rather than straight reporting of all the individual results. My bad. I think in your case, slurpee55's suggestion might be the best bet.

[7omislav]

Yes, with slurpee55's suggestion I'm getting close , but not quite.
I want to group the report by fourth field

[rbalaji]

Can you post a sample of what you want to see as the final output. If you group by the 4th field, will the output not look like what I envisioned with the 4th field on the sides running up and down and the gender running left-to-right across the top?

[7omislav]

Not if there are different numbers of males and females in category...
I've attached sample in excel format.
Sheet1 is sample of data I have, and in Sheet2 is what I want to look in report

[rbalaji]

There is absolutely no way to get the format you want natively using an SQL query. What you want is multiple subreports arranged into one main report to simulate the look of the excel sheet.

Just to be clear, there is actually no grouping going on in the database sense of the term (grouping by a field has a specific meaning in database terms). All you are doing is collecting items of a particular type and arranging the collections in different parts of a page in a two-column layout.

[7omislav]

Maybe it was bad example with excel
I want this (and I can do that with slurpee55's suggestion)

Originally Posted by 7omislav

Sorry that's not what I want
I need to get from



to

but I want additional grouping by another row (not in the pictures)

[7omislav]

OK, here's what I've done so far...
I want the TYPE's on left and right side of the Report1 to be alligned

[rbalaji]

OK, took a look at your report and your requirement. It is going to be very difficult to do. I will root around and see if I can think of some way to accomplish this easily, but nothing pops up right away.

[OBP]

Like this?

[slurpee55]

messier, too!

[7omislav]

Originally Posted by slurpee55

messier, too!

That was just example (bad one)