Table to report design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 
Back
Top