hi all I wonder if I can group using 2 fields . Let's Say I have a table and in there I have field1 and field2 and field3
field1 field2 field3
1 111
1 222
1 333
444

So base on data above let's say active is 1. So grouping by 1 I got 3 counts and not active(nothing or 0) I got one count. Or do I have 2 create 2 queries and join them? Someone has an idea? thanks

Hi,

Your example did not display as you probably intended. To fix that, you'll need to use a "code" block.

As you type your post, click on the "Code" link below to create a code block, then you can type your code inside the code block and it will preserve the spaces for display.

Just my 2 cents...

Thanks alot DBguy

You're welcome. It makes a lot more sense now!

Based on your limited sample, you may be able to use a GROUP BY of something like this:

GROUP BY field1 & field2

(untested)
Hope that helps...

thanks DB guy it works well I have tested it. One more question how can you count how many people got GPA from 2to 3 and from 3 to 4... something like that...do you have any idea?
thanks

Glad to hear that!

I would try something like:

SELECT Sum(IIf(GPA Between 2 And 2.99, 1, 0)) As GPA2To3, Sum(IIf(GPA Between 3 And 3.99, 1, 0)) As GPA3To4
FROM TableName

Either that, or look into the Partition() function.

(untested)
Hope that helps...

Oh I just got it using Sum(IIf([CumulativeGPA]>=2.5 And [CumulativeGPA]<=2.99,1,0)) as expression I have tested it and got correct result . If I want to have sum of my count for each group or percentage for each female or male over total of each group in report .. will I create unbound field in report or in query?

thanks DBguy

Hi,

Glad to hear you were able to make it work!

I think you can perform the calculation in either one but I would suggest trying the Query first and if it doesn't work, try the Report.

Hope that helps...

thanks DBguys I will try it later.

Once again Thanks

You're very welcome. Good luck with your project.

Hi,

but this one seem easy but I have no clue to do it in query or report when calculate total or percentage from each group. Let's me give you an example


so let's say I got data for each active and not active , how can I do this kind of report using query or report to come up to this percentage number for each groupA and GroupB ...and so on.

I think you did this kind of report before but I have no idea to do it in query or report ...since I did a little of sum or total only. I hope you understand example above . Could anyone help me with this?

thanks