Table to report design

[Joe C]

Hello,

I am looking to create a report down the road where sums of categories are
created.

I currently have a table with a field that is populated by a calculation in
a query. It is further categorized by an account. For example:

2 dogs 100
1 cats 200
3 birds 300
3 dogs 150

If on a report I need to see:

dogs 250 cats 200 birds 300

How would I do that? Should I have different fields in the Table's design or
in the Report's design?
Thanks
JC papi


BTW How do I post to two groups, this one and the report design?

 

[Rick B]

You already asked this in the REPORT newsgroup. Please stick to one post
per question. No need in two people investing time to research and respond
if the first answer is correct.

 

[Joe C]

Rick,

I asked in two places because I did not know where the question is
appropriate.

JC

 

[Pat Hartman \(MVP\)]

If you'd like a single question to appear in multiple newsgroups simply add
the additional newsgroup names to the Newsgroups: field separated by a
semi-colon.
microsoft.public.access.tablesdbdesign;microsoft.public.access.reports