One Table couple of Totals

[grumbachr]

I'm creating a table to track "Mailing"

Mailing can be several types, so I have a field for "types" and this is set by a specific value list ( Letter, Cards, Brochures) Another field is the number being sent.

So far it been really easy for me to get a Total of the Mailings:Sent field but I want be able to break this down by their types. This is were I'm struggling.

Please point me in the right direction on this one. It seems like it should be easy but it passing my by.

All suggestions are appreciated.

[bcooney]

I can think of several approaches.

If you are staying within one table, you can create a self-join relationship for each type and create a calc field, sum (selfjoinLetter::MailingsSent). You would need a global calc field for each type that simply equals the type (gLetters_c = "Letter").

Or run a subsummary report by type.

Or create a multi-criteria relationship from another table to the mailings table that includes type. (From client to mailings where clientid=clientid and type=type).

PS: You refer to Mailings:Sent. I would advise against using colons in field names.

Edited February 23, 2008 by Guest