'Count' two fields in a Query

[dr4ke]

Afternoon,

I have a query which provides a range of data (most importantly; MailboxSize and BusinessUnit). I would like to count mailbox sizes by BusinessUnit, i.e. below.

Business unit 1 - X amount of 100GB mailbox's
Business unit 1 - X amount of 200GB Mailbox's

Business unit 2 - X amount of 100GB Mailbox's


Business Unit 2 - X amount of 200GB Mailbox's

is this possible without having a separate query for each Business Unit or Mailbox Size?

Thanks

[alansidman]

Create an aggregate query BusinessUnit. MailboxSize added to the grid twice. Group on the BusinessUnit and the first MailBoxSize and Count the second MailBoxSize.

Look here: http://www.techonthenet.com/access/f...eric/count.php

[dr4ke]

Perfect Thanks :-)